Hi,
I have written a SQL 2008 R2 RDL and deployed it to the report server and I can run this report as expected through the standard Report Manager website.
I am now attempting to write an application that will use the Syncfusion ReportViewer to render reports.
I am currently testing the functionality against this single report but will eventually be pulling back a list of all reports on the Report Server and allowing the user to select from the available reports which report to run and rendering that in a view that contains the ReportViewer.
The report I have written has 6 parameters, 2 parameters are dates, there are 2 multi-value select parameters which are populated by datasets embedded in the report, finally there are 2 hidden, nullable parameters with a specified default value of null.
When I try and render this report in a simple WPF application as per the examples provided, the ReportViewer gives an error requesting a value for the first of my hidden parameters - how do I prevent this?
Furthermore, if I try to set values for the hidden parameters in code using the SetParameters method, I then get an error which states that my stored procedure has too many arguments specified. I wondered if this might be an issue with having multiple values selected for 2 of the other parameters (even though this works perfectly on the Report Server itself) so I selected only one item in each of those params and selected View Report at which point I then get the same error about needing to provide a value for my hidden parameters.
It feels like perhaps I am missing a step that would resolve this whole issue, but I have been unable to find anything relating to this in the documentation or forums.
Can you please tell me what I need to do for the ReportViewer control to respect the hidden parameter values in the RDL?
Can you also tell me whether there is any issue with using the Join Expression to concatenate the values selected in a multi-value parameter to pass to my stored procedure variable as a comma-separated list? Could this be the cause of the "too many arguments" error?
Thanks in advance
