Today i came across a very interesting finding regarding one of the most common ssrs error while using sub reports — One or more parameters were not specified for the subreport which is normally accompanied by actual report error —Error: Subreport could not be shown
There can be various reasons for the error which are listed below:
- Problem with the dataset of the subreport– Run the sub report independently n make sure that it is working
- Not passing an actual value to one of the parameters of the subreport – Check whether the names n values of parameters passed from main report to sub report are correct.
When i started getting this error at my production server, i first checked the above 2 points which are available at most of the google blogs but the problem was still there.
The problem was not there if i run in my local box with VS 2008 but if i go to the report manager and run the main file, it was throwing the error again.
Then i changed the way i was inserting my sub report in my main report and it solved the problem
Instead of directly inserting sub report by right click n then adding to the main report, i first added a table.
Then removed the extra columns as i needed only one and drag n dropped the subreport rdl to the column.
After adding the parameters, it started working 🙂
Don’t know whether it might solve the problem for you guys but just thought of sharing my experience
Prashant