CODEWITHSUNDEEP
ssrs-2008
JackReacher
JackReacher

Reputation: 465

Error: Subreport could not be shown. Sub Report works in Preview - but not when deployed

I have a main report that runs multiple sub-reports. One of my sub reports runs perfectly fine in Preview, but when I deploy the report and run it from the browser, i simply get:

Error: Subreport could not be shown.

I've done some research and I am still not sure what the issue is. I've tried it in different browsers, my data sources for both the main report and sub report use the same shared data sources. And the main report and the parameters seem to pass fine (since it works in preview, I am assuming).

The error doesn't tell me much - has anyone else had this issue? Or any ideas how to debug? Many thanks!

Upvotes: 5

Views: 17594

Answers (3)

Anthony Fernández
Anthony Fernández

Reputation: 1

If you are working with multiples servers, be careful of where the datasets for all the sub reports are pointing to.

Upvotes: 0

Abhinesh Maddala
Abhinesh Maddala

Reputation: 21

Check the parameters of the Sub Report. Correcting them appropriately will make it working.

Upvotes: 1

JackReacher
JackReacher

Reputation: 465

Issue resolved. I needed to deploy my subreport as well, not just build.

Upvotes: 4

Related Questions