After a couple of days of tearing my hair out trying to figure out why Telerik Reporting wasn't passing parameters to SQL server Stored Procedures I've finally found the issue.
I was constantly getting this error - "An error has occurred while processing Report 'ReportNameHere': Procedure or function 'storedProcedureName' expects parameter '@ParameterName', which was not supplied.".
There's a bug with Glimpse/Telerik Reporting whereby if you have Glimpse installed, Telerik doesn't pass parameters to SQL Server. I've run fiddler using an MVC app with glimpse and telerik reporting installed and can see that the parameters are passed, but they get blocked/removed somewhere.
I've tried with the HTML5 MVC wrapper and just the HTML5 report but no luck. It seems to work with parameters that are passed to straight SQL statements in a SqlDataSource but not stored procedures.
See here for more info - https://github.com/Glimpse/Glimpse/issues/538
1 Answer, 1 is accepted
Thank you for this post and the detailed information.
In general, the SqlDataSource component uses the installed on the machine .NET data providers, where parameters may not be passed correctly if Glimpse affects the functionality of data providers. Our developers will research further the issue and what can be done from our side.
Regards,
Stef
Telerik