SEO

#1 (**permalink**) 02-29-2008, 05:35 AM

lfarr...@setfocus.com Jan 12, 8:28 pm show options

Newsgroups: microsoft.public.sqlserver.reportingsvcs
From: lfarr...@setfocus.com - Find messages by this author
Date: 12 Jan 2005 20:28:28 -0800
Local: Wed, Jan 12 2005 8:28 pm
Subject: ReportParameter.ValidValues
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

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--

#2 (**permalink**) 02-29-2008, 05:35 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!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode