Pass integer type parameters to ssrs Reports

Question

I have a report with integer parameters and while passing the parameters from WPF client to ReportParameter object, it gives an error:

"The best overloaded method match for 'Microsoft.Reporting.WinForms.ReportParameter.ReportParameter(string, string[])' has some invalid arguments".

How can I pass an integer type parameter to my SSRS report from my WPF client?

My Parameter in the rdl is created as Integer. When I pass it as string using ToString(), the report generates and shows error message - "Procedure or function spReport has too many arguments specified." — Shakti Prakash Singh

Diego Diego · Accepted Answer · 2012-05-11T16:51:05

you should not use toString() to pass values to a integer parameter.

The ideal for parameters being passed from outside the report is set them as "Text". You dont even have to cast them (to integer in your case) on the dataset. For example, if you have a ID parameter like this:

where ID=@ID

you can create it as text and pass it as a parameter from the URL like if it were a text

Pass integer type parameters to ssrs Reports

1 Answers