Little problem

I'm trying to render a report inside an iframe, just setting the src
attribute of the iframe to the report url. When the report needs no
parameters, this works just fine, but if it needs parameters, the
report viewer will keep asking for them, although I used
rc:Paremeters=False in the url. If I paste the url I'm using in ie or
firefox, the report will render fine and will use the paremeters
specified on the url itself, but that same url will never work inside
the iframe.
Any ideas?
Thanks in advance.> Any ideas?
I would try to pass null values for these parameters.
The syntax is :
ParameterName:isnull=true
Med Bouchenafa
"jman0" <jman0@.zapo.net> a écrit dans le message de news:
1135616400.317347.23290@.g49g2000cwa.googlegroups.com...
> I'm trying to render a report inside an iframe, just setting the src
> attribute of the iframe to the report url. When the report needs no
> parameters, this works just fine, but if it needs parameters, the
> report viewer will keep asking for them, although I used
> rc:Paremeters=False in the url. If I paste the url I'm using in ie or
> firefox, the report will render fine and will use the paremeters
> specified on the url itself, but that same url will never work inside
> the iframe.
>
> Thanks in advance.
>

Listing rows "missing" information?

Here is how part of our database works. We have a table called "Events." Inside the "Events" table, we list various events which takes place for each of our clients. The first event for any client should be "Opened Case." However, some of my employees have not been listing this event so we do not know when the case was actually opened. In theory, all cases should have an "Opened Case" event in them. Is there a way to query that table to find which cases do not contain that event? Or is that more a programming issue? Thanks for any help?I'd suggest something like:SELECT DISTINCT caseID
FROM events AS a
WHERE NOT EXISTS (SELECT *
FROM events AS b
WHERE b.caseID = a.caseID
AND 'Case Opened' = b.eventType)
ORDER BY caseID-PatP|||or something like --select caseID
from events
group
by caseID
having 0
= sum(
case when eventType = 'Case Opened'
then 1 else 0
end ):)|||My, aren't we feeling deviant today! Heck, Rudy's solution will even work in MySQL!

-PatP|||deviant? heh

i was just thinking that yours involves a join (expensive), a NOT EXISTS (expensive), and a sort to remove dupes (expensive)

mine's just one sort, to do grouping

hey pat, did you give that Sock Hop channel a try? i was hoping you'd come back with some comment like "oh wow, i love that stuff!" (which was my reaction)sql

ListBox

is it possible that a matrix inside a listbox1 and the listbox1 inside
another listbox2?
---
|list box2 |
| --
| | listbox1 |
| | --
| | |matrix |
| | | |
| | --
| | |
| --
| |
---
Thanksmayb i should say list instead of listbox...|||Try placing a subreport(s) inside a table. I have used this "layered"
concept before. HTH.
David
"SL" <SL@.discussions.microsoft.com> wrote in message
news:EAD22A3C-7A21-4A8D-BF05-43508BE1FBD9@.microsoft.com...
> is it possible that a matrix inside a listbox1 and the listbox1 inside
> another listbox2?
> ---
> |list box2 |
> | --
> | | listbox1 |
> | | --
> | | |matrix |
> | | | |
> | | --
> | | |
> | --
> | |
> ---
> Thanks|||i have found a way to solve my problem.. thanks anyway.

List of tables in use by a view

Hi,

I wonder if I can list the tables (and views) used inside a view, I mean the list of tables in the FROM clause

Thanks,

Arty

An easy way is to call the "sp_depends @.objname" stored procedure. Within Management Studio, you can also right-click on an object and choose "View Dependencies"

Peter

|||I would like to do it inside VB.NET or C# using the SMO|||One way is to use SMO like:

Database db = srv.Databases["test"];

string a = "sp_depends " + objname;

db.ExecuteWithResults(a);
There are other ways of using SMO to get the dependency information, but I do not have the code available.

Peter

List of SQL Server 7.0/2000 instances running

How to get the list of instance of SQL Server 7.0/2000 running on the local machine inside my domain...
I need to prepare the list of all sql instances.. pls help if possible to find details using sql query.I'd start with:EXECUTE master.dbo.xp_cmdshell 'osql -L'You might have to refine it a bit, but it is a place to start.

-PatP

List inside a List...

I need to create a List inside a List in the designer, but I am runninginto a lot of issues. The main problem is that I dont know what Imdoing and I dont have any kind of tutorial or model to follow. Doesanybody know of any links to any tutorials on creating lists and listsinside lists in Reporting Services? I am consulting Google as well...
Hi,
Why don't you use subreports. I believe it will be easier.
Eralper

|||

I have used Lists in Lists for a bunch of reports, and used them for drill down and grouping and everything, its GREAT! Just drag out a list control, hook it up to a dataset, edit the details grouping and there ya have it, a list grouped on an expression, like dates or usernames, then open that list up a bit, drag a new list inside, set its properties, maybe edit the detail grouping, making sure to name it something different than list1_details_group or whatever, then you can control through the properties the visibility of the list to give you a drill down feel, it should be fairly simple. If you want an example I could send you a little something.

List control and pdf export issues

I have created a report that contained a subreport that was databound inside a table but I was getting errors when I export to excel - "Subreports within table/matrix cells are ignored".

So I changed my report to bind the subreport to a list control instead of a table and it exports to excel fine but I now have new issues:

1) When I export to pdf it seems to ignore width and height properties, creating a blank page every other page (because it thinks the list control is wider than the page), and it also overlaps other elements below the list control.

2) I also seems to have lost the paging in the viewer control that is handled by setting the interactive height property.

Are these known limitations of the list control and pdf or do I have something wrong in the way I have set-up the report. I can provide .rdlc file samples if necessary.

Thank you

Lee Whitney

For your first issue, I guess the width of your subreport (in designer) is more than the width of the subreport control in your main report. For example, if you had used 8 inches in your subreport designer and if the width of the subreport control in your main report is only 7 inches, it will be spilled to the next page.

Hopefully this will solve your other issues as well.

Shyam

|||

I already made sure that my sub report width is less than the control width, in fact if I use the table control rather than the list control (and the widths for both controls are the same) the table control exports just fine to pdf where the list control does not. The list control seems to add a colspan=2 to the raw html though I don't know why but this seems to be my culprit though I have no idea how to get rs not to render the html in this fashion.Thanks

List Box Page Number

Hello,

I have a matrix inside a list box that groups by "question id" to display matrices with summaries for each question. I have checked the box "Insert page break after this list".

I want to be able to place the list box number next to the question, so that I will see something like:

1. Name

2. Category

3. Age

Is there a way to do this? Can I access the current number within the list? If I try the Globals!PageNumber variable, I get an error saying that the variable can only be used in a header or footer.

Thanks,

Michael

Hi,

Are you using any Grouping inside the list? If you are, I believe you can get the number within each list using the following expression:

=RunningValue((<Your List Grouping Field>),CountDistinct,"DataSet1") where "DataSet1" would be the name of your dataset.

If you do not have any grouping for the list, you could try using 'question id' in the expression instead.

Hope it helps.

-Aayush

|||

Aayush,

Thank You! That was exactly what I needed! Worked like a charm!

Michael