Working with SSRS 2005
Recently asked to replace Crystal Reporting Services with SQL Server Reporting Services I went about reading, testing, reading, and testing yet again the features of SSRS.
I found the Report Designer (SQL Server Business Intelligence Development Studio) to be a bit clunky… but, it does work once you get the hang of it. My main complaint is that its so tedious to reference values =Fields!foobar.Value … not sure why these aren’t aliased as with Crystal Reports. And the WYSIWYG leaves me scratching my head a bit b/c it just doesn’t work as fluidly as one would expect it to.
Dipping a bit more into the programming I found I could use the Microsoft Report Viewer to display the report by specifying a URL (in contrast to using the web services which I did not need). Unfortunately it took me a full two hours to determine how to set parameter values! …. While I may have moments of lunacy, last I checked I was not an idiot, so why was this not made more clear by the documentation since it seems like such a common need?
For those of you facing the same issue, here is how you do it:
//dynamically set parameter values
ReportParameter reportParams = new ReportParameter(”paramName”, “yourValue”);
reportViewer1.ServerReport.SetParameters(new ReportParameter[] {reportParams});
*Note that the parameters are case sensitive.
No related posts.
