Share
ReportHello:
I have an SSRS report with a subreport. Each report has two parameters. And, the parameters are the same. One pulls data from a work center, while the other pulls data from manufacturing orders.
If I run either the main report or the subreport, with one value for each parameter, the report(s) runs fine. But, if I choose say every value in each parameter, no data appears.
The entire project is based on SQL stored procedures that I created. I tested those stored procedures in SQL, and they display data accurately when I run the same tests that I ran in SSRS. So, the problem is definitely in SSRS itself.
I have been reading today online about how developers place the following expressions within the main dataset of the SSRS report and subreport respectively:
=join(Parameters!ParamName.Value,",")
=Split(join(Parameters!ParamName.Value,","),",")
Also, the “verbiage” online says to modify the stored procedures’ parameter “@-symbols” to contain the following: ‘,’. I have done all of this, but I still get the same result—blank data upon choosing multiple values. Also, SSRS gives off a warning shown at the end of this e-mail.
Does anyone have any suggestions?
Thanks!
John
Warning 1 [rsInvalidExpressionDataType] The Value expression used in textrun ‘currentstep1.Paragraphs[0].TextRuns[0]’ returned a data type that is not valid. F:\SSRS\Manufacturing Scheduling\Mfg Scheduling\Mfg Scheduling\Current Step Subreport.rdl 0 0
*This post is locked for comments
All responses (
Answers (
291,280
