sql server reporting services: ReportParameter.ValidValues -- sql server reporting services

You're in the

sql server reporting services

group:

ReportParameter.ValidValues

lfarrell NO[at]SPAM setfocus.com
1/12/2005 8:28:28 PM

sql server reporting services: I have been assigned to create a new report subscription form. I have
done everything but prompt the user for values. So there are a bunch
of reports with varied parameters. Some of these parameters are
hard-coded lists and others are DataSetReference. How do I provide the
subscriber with an accurate list of valid values?

I was thinking something like:
ReportParameters[0].reportParameter.ValidValues
but that comes back null.

I tried reportService.GetReportParameters(report, historyID,
forRendering, values, credentials)
Values comes back null.

Please help!

Thank you!

--Larry--

Re: ReportParameter.ValidValues

Lev Semenets [MSFT]
1/12/2005 11:48:43 PM

"values" in GetReportParameters is used to validate parameter values.
Actual parameters are returned by GetReportParameters.
You can try something like this:

ReportParameter [ ] rp = reportService.GetReportParameters(report,
forRendering, historyID, null, credentials);

rp[0].ValidValues should contain valid values.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: ReportParameter.ValidValues

lfarrell NO[at]SPAM setfocus.com
1/13/2005 6:22:02 AM

Thank you, but that didn't work,

The ValidValues is <undefined value>

I used the following code:

ValidValue[] vv = new ValidValue[0];

parameters = server.GetReportParameters(thisfolder, null, false,
Paramvalues, Paramcredentials);

if (parameters.Length != 0)
{
vv = parameters[0].ValidValues;
}

when I look at parameter[0] (and 1 as well) I have ValidValues
<undefined value>
CalidValuesQueryBased = true
ValidValuesQueryBasedSpecified = true

Re: ReportParameter.ValidValues

lfarrell NO[at]SPAM setfocus.com
1/13/2005 6:22:03 AM

Re: ReportParameter.ValidValues

lfarrell NO[at]SPAM setfocus.com
1/13/2005 10:22:25 AM

Thanks to Daniel Dieb, I fixed my problem. He commented on a similar
post:

If ForRendering has a value of false, the parameter meta data returned
represents the parameter data that is currently associated with the
specified report. If any parameters values are based on a query and you
are
interested in returning the query-based parameters valid values list,
you
need to set ForRendering to true, In addition, for query based
parameters,
you need to ensure that you have passed in all of the credential
information
required to return the query parameters.
I set this parm to true and got my values!!

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn