I am trying to build web application (ASP.NET) that will be used to display an SSRS report.
My report has 4 cascading parameters - A,B,C and D. C and D "depend" logically on the value of A (this means that the DataSets of C and D are filtered based on the value of A). Programatically (in SSRS) B depends on A, C depends on B and D depends on C.
I am trying to set them in advance the following way:
ReportParameter rp0 = new ReportParameter("Project", "P1");
ReportParameter rp1 = new ReportParameter("TopX", "Top5");
ReportParameter rp2 = new ReportParameter("Companies", "Company1");
MyReportViewer.ShowParameterPrompts = false;
MyReportViewer.ServerReport.SetParameters(new ReportParameter[] {rp0, rp1, rp2});
MyReportViewer.ServerReport.Refresh();
When I do that I get a mistake that TopX parameter has no value. This is the second parameter - it has a default value (="Top1").
Could anybody assist? Is there any way to dynamically query the SSRS report for the values available for each parameter and then select a value?