Link to home
Start Free TrialLog in
Avatar of alibah
alibahFlag for United States of America

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!
Avatar of Rob Farley
Rob Farley
Flag of Australia image

The subreport is still in its original location, which the user may not have access to.

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
Avatar of alibah

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/SubReport.rdl

Rob
Avatar of alibah

ASKER

Yeah, but maybe I'm doing the first part wrong.  What goes before /SubReportFolder?  Is it <servername>/Reports/SubReportFolder 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.
ASKER CERTIFIED SOLUTION
Avatar of Rob Farley
Rob Farley
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial