alibah
asked on
Reporting Services - Linked Report w/ subreport error
I have uploaded a report to Report Manager in Reporting Services 2008. The report includes a subreport and everything runs fine from the folder where the report is uploaded. I've created a Linked Report from the main report and placed it in a different folder in Report Manager. When I try to run the Linked Report, I'm getting a "Subreport could not be shown" error. I've tried uploading the subreport to the same folder as the linked report, but I still get the same error. I've searched online for help, but am not coming across an answers. Hoping someone here might have some ideas.
Thanks!
Thanks!
ASKER
I can't seem to get my original report to call the subreport properly when it's in a different folder. I've read online that I should use a relative path instead of just the file name, but I must be doing it wrong because it never works for me.
You're using forward-slash rather than backslash, right?
Like... ../SubReportFolder/SubRepo rt.rdl
Rob
Like... ../SubReportFolder/SubRepo
Rob
ASKER
Yeah, but maybe I'm doing the first part wrong. What goes before /SubReportFolder? Is it <servername>/Reports/SubRe portFolder or just /SubReportFolder?
I have run into this situation if the data souce on both the sub report and the main report is not using a SQL Native data source connection string.
You do need a SQL Native Data Source setting as historically it is not supported by OLEDB. ( not sure if MS has changed this yet but it was in discussion) You may want to look at your Data Source for Native.
You do need a SQL Native Data Source setting as historically it is not supported by OLEDB. ( not sure if MS has changed this yet but it was in discussion) You may want to look at your Data Source for Native.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I would recommend making a special folder for Subreports. You can always set it to Hidden, so that people don't realise it's there. Then tell the original report to get the Subreport from there instead.
I know it's a pain, I wish it was different too.
Rob