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
I was facing this problem, Anyway worked for me also. Just drag and drop the sub report. Thanks prashant.
Hi prashant. What is the Reporting Service version? I’m using 2008 but it was throwing the error… Please answer me!!
P.D. Sorry if my English is bad….
Its 2008
Unbelievable, I as battling with this problem for a few days and almost gave up…Thanks Prashant
Thank you Prashant.It worked for me.