Monday, 27 June 2016

SSRS Error- One or more parameters were not specified for the subreport

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:
  1. Problem with the dataset of the subreport– Run the sub report independently n make sure that it is working
  2. 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

1 comment:

  1. Finding the time and actual effort to create a superb article like this is great thing. I’ll learn many new stuff right here! Good luck for the next post buddy..
    MSBI Training in Chennai

    ReplyDelete