all groups > sql server reporting services > september 2004 >
You're in the

sql server reporting services

group:

Retrieve Dataset using RS Web Service?


Retrieve Dataset using RS Web Service? Dave Morrow
9/24/2004 1:49:04 PM
sql server reporting services:
I am using the RS web service to generate reports. I know it is possible to
generate lists of available reports, together with a list of required
parameters for each. But is it possible to get a list of valid values for
each parameter via the web service? i.e. retrieve the dataset results that
are used to poulate the filter when the report is viewed using Report
Manager. This would save me writing a query to populate a list in my custom
Re: Retrieve Dataset using RS Web Service? Brian Almond
9/24/2004 3:38:39 PM
[quoted text, click to view]

You can check to see if a parameter has ValidValuesQueryBased specified,
and then build a combobox from the ValidValues collection of the
ReportParameter object. I've written a small report launcher in C#
which does this and it works well.

Re: Retrieve Dataset using RS Web Service? Brian Almond
9/24/2004 3:47:56 PM
<snip>
[quoted text, click to view]
<snip>

Edit: ValidValues is a property of the ReportParameter class, and is of
type ValidValue[].

Re: Retrieve Dataset using RS Web Service? Dave Morrow
9/27/2004 1:07:03 PM
Thanks for your help, Brian. Much appreciated.

[quoted text, click to view]
AddThis Social Bookmark Button