Linking linked sub reports to a linked Report

Question

I have a report, report A, located in folder A location.

I have a linked report of Report A, located in folder B location.

I have a sub report, sub report A, located in folder A location.

I have a linked sub report of sub report A, located in folder location b.

Linked Report A works to an extent when its in Location B, but all of its 
sub reports are not working. (Error: Subreport could not be shown.)

When you go into sub report A in location B and run it as a "report" and it 
works just fine, so the report works, it just doesn't like being a linked sub 
report to a linked report.

Any ideas?

Thanks all,
Keith

Answer 1

This is not the correct forum for your query.

---

Nitesh Rai- Please mark the post as answered if it answers your question

Answer 2

Excuse me?  Uhm, this is the SSRS forum, right? 

Answer 3

Oh..Sorry......I thought this is SSIS forum...Sorry

---

Nitesh Rai- Please mark the post as answered if it answers your question

Answer 4

Hi,

A linked report is a report server item that provides an access point to an existing report. Conceptually, it is similar to a program shortcut that you use to run a program or open a file. So, it should not have this error on the linked report.  In additon, you also can specify the UNC of the subreport, i.e /Folder1/yoursubreport 

Please make it detailed and clear if it can't help you.

thanks,
Jerry

Answer 5

Hi,

A linked report is a report server item that provides an access point to an existing report. Conceptually, it is similar to a program shortcut that you use to run a program or open a file. So, it should not have this error on the linked report.  In additon, you also can specify the UNC of the subreport, i.e /Folder1/yoursubreport 

Please make it detailed and clear if it can't help you.

thanks,
Jerry

Answer 6

I think you're speaking about hyperlinked (action) reports rather than sub reports that are linked to linked reports.  I don't know that there is a way to direct a linked report to find its linked sub reports in a certain directory.  You post them to Report Manager and report manager manages that linking.  Whereas in a hyperlinked report, I control things like the unc path.  Did I miss something or have I found a potential bug?

Answer 7

Hi,

Assume there 3 folders in Home directory of the report server, they are Folder1, Folder2 and Folder3. In each folder, there is a report. Report1 in Folder1, Report2 in Folder2, Report3 in Folder3.

Now, i have the report1 linked to report2, report2 linked report3.

Report2 subreport control's "use this report as a subreport" should be /Folder1/Report1.
Report3 subreport control's "use this report as a subreport" should be /Folder2/Report2.

Then view the report3 in the folder3, it works fine. 

Note: if the subreport and mainreport are in differenct location, please use the path string like the above for the subreport.

Please let me know if you have more question.

thanks,
Jerry

Answer 8

Sorry, but that doesn't work.  I get "Error: Subreport could not be shown."


First of all, it breaks when you do that in Visual Studio/BIDS (which makes sense because your hard drive that you store the reports on do not necessarily match your report manager folder structure), then when you post it to Report manager you get the same error.

So have I found a bug?  Have you tried linked sub reports?

Answer 9

Hi,

In BIDS, it doesn't work for such subreport path. You need to pulish them into your report server to run. Maybe i did not understand what's the "Linked Sub reports" in your secario. Could you provide more details on it? Once i get it, i will do the test and give you a feedback asap.

thanks,
Jerry

Answer 10

I don't know what would clarify it except to say that my original post above is fully accurate and that I am not speaking of hyperlinked (action) reports but rather linked sub reports that are linked to linked reports.  Hyperlinks are not a part of this scenario.  I'll repost my original question and ask you to unpack with me whatever specifcally you are asking me to clarify.

I have a report, report A, located in folder A location.

I have a linked report of Report A, located in folder B location.

I have a sub report, sub report A, located in folder A location.

I have a linked sub report of sub report A, located in folder location b.

Linked Report A works to an extent when its in Location B, but all of its
sub reports, which are at this point linked sub reports, are not working. (Error: Subreport could not be shown.)

When you go into sub report A in location B and run it as a "report" and it
works just fine, so the report works, it just doesn't like being a linked sub
report to a linked report.