Sub Report Not Recognized When File Name Is Changed
HI, I have a report that is comprised entirely of sub reports that we can call the Overview Report for these purposes. The Overview Report has parameters that match the parameters in each of the subreports and everything works perfectly fine. No problems. The problem comes in when I change the name of one of the original reports (which needs to happen so I can deploy). I take the following steps: 1. Right click on the report in Solution Explorer. 2. Select Rename 3. Change the name 4. Go to Overview Report 5. Right click on subreport of the renamed report 6. Select Subreport Properties 7. Under General, Select the renamed report from the dropdown under: Use this report as a subreport:" 8. Select OK. Seems like all should work now, but alas, SSRS wouldn't be that easy. When I run the Overview Report, I get an error message: "The subreport 'xxx' could not be found at the specified location. Please verify that the subreport has been published and that the name is correct." Well, the subreport link has been changed to match the name of the report (steps 5-8 above). And I don't believe publishing is an issue as I am in a development environment in a single directory. I even looked in the XML code, and the "report name" matches the new name <ReportName>xxx</ReportName> Sooo...any ideas out there? I have to change the names of all six files that are subreports in the Overview Report and I really don't want to start from scratch if I can avoid it. Thanks so much! Kim
July 18th, 2012 5:18pm

Hi There Thanks for your posting. Did you try to run the Sub report separately, it that working. Try to run the sub report separately and one thing more when we preview a report, the data for the report is cached to a file on the local computer. When we preview the same report report Designer retrieves the cached copy rather than rerunning the query. The data file is saved as <reportname>.rdl.data in the same directory as the report definition file. In normal situation, the cached file doesnt work once we modify the query. At this time, I still suggest that you delete the cached .rdl.data file and then check the issue again Many thanks Syed Qazafi Anjum
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2012 5:48pm

Yup, the cached files seem to be the answer. I deleted them all and re-ran without a problem. Good to know for future projects as well... Thanks so much! Kim
July 18th, 2012 7:14pm

Hi There Thanks for your posting. It is Nice to hear that your problem has been resolved. Good luck for your project. Can you Please click "Mark as Answer" if this resolves your problem Many thanks Syed Qazafi Anjum
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2012 7:21pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics