Reporting Services 2005 Catalog table

Hi
Can someone please point me in the right direction to find all the possible values and their meaning for the Type column found in the Catalog table.

Thanks
JWWe don't document the tables structure for the RS catalog. If you want to interract with the report server, you should use the SOAP APIs.

Thanks
Tudor

Reporting Services 2000 Filtering based on a text parameter

I've looked through the reporting services help and it's very vague on how to do this.

What I want to do is set up a prompt with three values; Open, Closed, and Due for Completion.

Based on the user selection then a filter will be inserted, something like:If the user selects "Open" then Datatable.Status not in ('Closed', 'Cancelled', 'On Hold'), if the user selects "Closed" then Datatable.Status in ('Closed', 'Cancelled', 'On Hold'), if the user selects "Due for Completion" then Datatable.Completion date > getDate()-14.

In the Report Parameters screen there is a Value column for each label, but I haven't been able to work out how that value can be inserted into the where statement.

Thanks,

Bruce

Just use the parameter name you setup in the parameter dialog and insert it into SQL statement as @.ParameterName.

You can try the 'Multi-value ' option if want to allow user choose more then one values.

|||

OK here goes...

I've created a parameter in layout called Report_Type, and I've setup the following available values...

Label Value

Open requests.[Work Request Status] NOT IN ('Completed', 'Cancelled', 'Business Hold')

Closed requests.[Work Request Status] IN ('Completed', 'Cancelled', 'Business Hold')

Due For Completion requests.[Required By] > (getDate()-14)

Now I add a where statement to the SQL that reads "WHERE @.Report_Type"

The error I get is "syntax error or access violation".

Where am I going wrong?

Thanks.

Reporting Services

hi,
I trying to display list of values in the table footer. Here i am using
multivalued datafield and it is displaying only one value. How can I make the
footer to display all of the values of that field? Is there any other
solution?If it is a list of rows shouldn't that be in the details instead of the footer?
"sai" wrote:
> hi,
> I trying to display list of values in the table footer. Here i am using
> multivalued datafield and it is displaying only one value. How can I make the
> footer to display all of the values of that field? Is there any other
> solution?

Reporting Parameters with Jump to Report Action

I'm in Chart Properties > Data > Values > Edit.
Action tab > Jump to report > Parameters.

I want to jump to another report chart that is paramaterized. For "Parameter Value" I've already discovered you have to change the default "=Fields!xxx.Value" to "=Fields!xxx.UniqueName", but this only works if it is jumping to a single value parameter. I sometimes want to jump to multi-value parameter and don't know what expression should be. I want it to be something like "= included in Fields!xxx.BunchOfValues" but of course this option doesn't exist!

Any suggestions?

IN THIS CASE IN ORDER TO PASS MULTI VALUE PARAMETERS USE THE FOLLOWING SYNTAX

JOIN(PARAMETERS!YOURPARAM.VALUE,",")