Prev: Getting the weeknumber of the max value?
Next: Min/ Max/ Avg of DateDiff in a Table report by Groups
From: Wayne on 19 Jun 2008 12:59
Using SSRS2005, VS2005 (C#). Using Server Reports.

Report has two parameters, which allow nulls. Default for the two parameters
is null. Report runs fine when viewing report initially with null parameters.

Select a non-null value for either/both parameters. Report re-runs fine.

Set parameters back to null. Report re-runs for last selected non-null value
for that parameter.

ie:
All (null)
A (a)
B (b)
When All is initially selected, get both A & B.
When A is selected, get A.
When B is selected, get B.
When All is selected again, get B.
When A is selected, get A.
When All is selected again, get A.

null values are being set as:
Param[0] = new ReportParameter("Section");
non-null values are being set as:
Param[0] = new ReportParameter("Section", SectionValue);

Param array is then passed to a RunReport routine:

rvwReport.ProcessingMode = ProcessingMode.Remote;
rvwReport.ServerReport.ReportServerUrl = new Uri(reportServerUrl);
reportPath = reportPath + reportName;
rvwReport.ServerReport.ReportPath = reportPath;

rvwReport.ServerReport.SetParameters(reportParameters);
rvwReport.RefreshReport();

What has to be done to get the correct (null) value in there?
By tracing our code, we are putting a null in the parameter. But the report
isn't using it.

Thanks,
Wayne

 | 
Pages: 1
Prev: Getting the weeknumber of the max value?
Next: Min/ Max/ Avg of DateDiff in a Table report by Groups