sql server reporting services: Multiple subreports in a report -- sql server reporting services

Multiple subreports in a report

jackfreud
3/4/2005 7:50:20 AM

sql server reporting services: I'm trying to generate two reports from one reporting services URL, so
I created a "master report" that simploy contains two sub-reports.

When I run it in the preview browser, one subreport runs, and not the
2nd.

In the RS Manager, both subreports say nothing but "Error: Subreport
could not be shown".

I wonder if it's a datasource problem, or something else?

Thanks,

Jack

RE: Multiple subreports in a report

ProfessorKaos
3/4/2005 8:41:04 AM

I imagine that it is a datasource issue, if it runs fine in report designer
preview.
I have a report that has 5 subreports and the only problem/change that I had
to make was to make sure that the data source is set properly for all the
subreports. For some reason it looses it occasionally when the reports are
deployed.

[quoted text, click to view]

RE: Multiple subreports in a report

Tony Ballman
3/4/2005 9:33:01 AM

Just had similar issue. Make sure the subreport operates standalone, with the
correct datasource, and proper parameters are passed to the sub report
property on the main report.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.