I have a problem with a report containing a subreport not running successfully when deployed to the Report Server. The report runs successfully every time in the VS Development environment, so parameters are all setup correctly and the result is as expected accross the whole report. No errors or warnings are listed when building or deploying. the subreport is in the same project as the main report and deployed to the same folder in Report Manager. the individual subreport runs successfully in VS Studio (Preview Tab) and in the Report Manager portal. the main report runs but shows the error "Subreport could not be shown" for the subreport. Running SQL 2008 R2 Please advise.

Does Main Reports passes every parameter Correctly to the SubReport?

yes!!!still doesn't work

actually it works on VS Development environment very good, but after deploying i just get that error(subreport could not be shown)

Please have a look at this http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/fd14aa89-4984-4b28-9fea-9fc2255727c1

i deployed the report and subreport and set connections for them, still have problems

i just used a same shared data source for main report and the subreport, should i change that??

Hi Mina N, There is no need to change the data source of subreport. For the error “Subreport could not be shown”, it can be caused by various reasons: · Make sure that you have upload both latest main report and subreport to the report server by overwrite the original ones, as described here: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/0f556b62-20df-4266-a5ef-008c221d3b6d · Make sure that the Data Source of the subreport has been configured correctly on Report Manager 1. Navigate to the Security page of the subreport 2. In the security page, click Data Sources tab, choose the shared data source you have used in subreport If all information verified and the issue still exists, could you please post more error message reported in the log file (My server has the logs at: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles)? Thanks, Lola Please remember to mark the replies as answers if they help.

thx alot it worked :D

Hello I had the same error it was the link to my data source that was wrong, I saved the rdl and changed that link. It worked fine afterwards ThanksMomo