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