Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Reporting Services - Linked Report w/ subreport error

Posted on 2009-07-02
6
Medium Priority
?
587 Views
Last Modified: 2012-05-07
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!
0
Comment
Question by:alibah
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 15

Expert Comment

by:rob_farley
ID: 24769071
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
 

Author Comment

by:alibah
ID: 24769965
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
 
LVL 15

Expert Comment

by:rob_farley
ID: 24770596
You're using forward-slash rather than backslash, right?

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

Rob
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:alibah
ID: 24772953
Yeah, but maybe I'm doing the first part wrong.  What goes before /SubReportFolder?  Is it <servername>/Reports/SubReportFolder or just /SubReportFolder?
0
 
LVL 9

Expert Comment

by:Tone' Shelby
ID: 24774998
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
 
LVL 15

Accepted Solution

by:
rob_farley earned 2000 total points
ID: 24775298
It's two dots, to mean 'parent folder'
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question