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!
alibahAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rob_farleyCommented:
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
0
alibahAuthor Commented:
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.  
0
rob_farleyCommented:
You're using forward-slash rather than backslash, right?

Like... ../SubReportFolder/SubReport.rdl

Rob
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

alibahAuthor Commented:
Yeah, but maybe I'm doing the first part wrong.  What goes before /SubReportFolder?  Is it <servername>/Reports/SubReportFolder or just /SubReportFolder?
0
Tone' ShelbyMicrosoft® Power BI, Power Apps & O365 Design, DevelopmentCommented:
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.
0
rob_farleyCommented:
It's two dots, to mean 'parent folder'
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.