ReportParameter.ValidValues
Jul 23, 2005
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--
View 1 Replies
Apr 1, 2008
Hi,
I'm calling a report based on values collected from an ASP.NET page. It worked fine until I tried to pass a multivalue integer value.
ReportParameter seems to take a string[] just fine, but not a int[].
For example...
int[] incidents = prevPage.IncidentIDs;
string[] assets = prevPage.Assets;
ReportParameter[] parameters = new ReportParameter[2];
parameters[0] = new ReportParameter("IncidentID", incidents);
parameters[1] = new ReportParameter("Assets", assets);
throws the error: cannot convert from 'int[]' to 'string'
but changing incidents to a string like so:
string[] incidents = prevPage.IncidentIDs;
string[] assets = prevPage.Assets;
ReportParameter[] parameters = new ReportParameter[2];
parameters[0] = new ReportParameter("IncidentID", incidents);
parameters[1] = new ReportParameter("Assets", assets);
results in "The 'IncidentID' parameter is missing a value"
I've verified that incidents has values.
Any help is appreciated.
Thanks,
Tonya
View 14 Replies
View Related
Sep 20, 2007
Hi,
I have a bunch of code for integrating reporting services 2000 with our application, which has been running fine for quite a while. We've recently encountered a problem and i can't quite figure it out.
There is a set of code that creates controls for entering parameter values for our reports, which takes an array of ReportParameters as an argument. We loop through the parameters and create controls as appropriate. The check to see if we need to create a dropdownlist of parameters populated through a query looks a bit like this:
if (oParam.ValidValues != null)
{
//Create ddl based on the list of valid values.
}
This is where i am encountering a problem. One of our reports, that has been running fine until recently is now not getting a dropdownlist created for it's second parameter. When i run into the code, i can see that this parameter now thinks that it has a dependency on the first parameter (which it does not), and the list of ValidValues is null.
If i go into the report designer and change the order of the two parameters in the report, then it works fine, the list is populated and there seems to be no dependency. If i change it back, it is broken again. I've checked the query that populates the list, it is not parameterised and is a very simple kind of SELECT A, B FROM TABLEA. I've looked in the report parameters and i can see nothing there either.
Your help would be very much appreciated here. I am running SSRS with SP2 applied.
Paddy
View 1 Replies
View Related
