Last post Jun 26, 2013 12:50 PM by sridhar_rs
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?
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.
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.
Jun 26, 2013 12:50 PM|sridhar_rs|LINK
Refer the following links,
May be you have forgoten to deploy the SubReports as well.