Error 'the subreport could not be found at the specified location. Please verify that the subreport has been published and that the name is correct'
Generally speaking from what I have seen SSRS has THE WORST ERRORS KNOWN TO HUMANKIND on telling you what is wrong. Generally speaking I have seen this one and the main culprit is one of three things:
- The Project needs to be rebuilt as you made changes to a subreport and the report data is not current.
- The Report data is corrupt some how and needs to be erased (look in your FILE location and delete the *.rdl.data file.)
- Your parameter you are passing in is bad or in the wrong format. All Subreports having parameters NEED TO HAVE THEM PASSED IN, or they will not run and give an error the equivalent of 'object set to an instance of a null'.
When you insert a 'Subreport' you may right click and select 'properties'. It has a 'Parameters' side panel you need to select and you need to 'Add' (for each one in the correct order and type) a 'Name' (the parameter name of the report) and the matching 'Value' from the current report passed into it.
EG: So if I had a subreport that wanted a customer to show demographic info on them and I had a master report that had rows of Business data with a customer id each per row. If my subreport took a 'CustomerID' parameter I would have that for the Name and choose '[Customer_ID]' from the current Dataset to pass to it.
You must keep in mind you must 'Add' each seperate parameter that the sub report requires.
Delete all the *.rdl.data from your project solution folder.
If you have changed the name of the subreport and are getting this error in the preview, just click the 'refresh' icon while in preview mode.
Data is cached for faster preview. Subreports are treated the same way.
Hope this helps.