The reason can range from a connection problem on subreports datasource to a missing parameter during deployment. Please try running main report at the report server directly and see if it runs fine there. If it works on reports erver with all subreports,
it will work in report viewer as well.
Also, running on report server will help you get the detailed and correct error behind Subreport could not be shown error.
Thanks for your reply. The main report works all the times.
If I use link htt://reportserver/....report, it works too.
However, if I use report viwer, it works only in visual studio. The sub report only has one parameter is linked to a field in the main report. The main report has one parameter I need passed and it works.
Member
4 Points
37 Posts
Sub report show error when loading Server Report
Jun 21, 2013 12:42 PM|ying06|LINK
I develop a web application with visual studio 2010 and use a reportviewer control to show a SSIS report (remotely).
The report has several sub reports which works ok when I run through develop environment.
However, when I publish the site to IIS server.
All sub report shows: "Error: Sub report could not be shown."
Anyone knows what's possible reason?
Member
220 Points
64 Posts
Re: Sub report show error when loading Server Report
Jun 24, 2013 08:29 AM|Abhi.ssrs|LINK
The reason can range from a connection problem on subreports datasource to a missing parameter during deployment. Please try running main report at the report server directly and see if it runs fine there. If it works on reports erver with all subreports, it will work in report viewer as well.
Also, running on report server will help you get the detailed and correct error behind Subreport could not be shown error.
Member
4 Points
37 Posts
Re: Sub report show error when loading Server Report
Jun 25, 2013 02:11 PM|ying06|LINK
Thanks for your reply. The main report works all the times.
If I use link htt://reportserver/....report, it works too.
However, if I use report viwer, it works only in visual studio. The sub report only has one parameter is linked to a field in the main report. The main report has one parameter I need passed and it works.
Participant
1130 Points
349 Posts
Re: Sub report show error when loading Server Report
Jun 26, 2013 12:50 PM|sridhar_rs|LINK
Refer the following links,
May be you have forgoten to deploy the SubReports as well.
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/bf7401b3-a3f4-401a-80d8-690407fbdfd9/error-subreport-could-not-be-shown
http://stackoverflow.com/questions/16514186/error-subreport-could-not-be-shown-sub-report-works-in-preview-but-not-when
.RS.
Thank you very much,
Please if my reply helped you.