CODEWITHSUNDEEP
reporting-servicesssrs-2008
Las Ten
Las Ten

Reputation: 1175

Report structure from table

I have a large project with a lot of reports, but the items in the reports are quite standard, reusable with parameters. So I've made subreports, that's OK. Now I assemble the reports by adding subreports to them by hand, plus setting the parameters, also by hand.

I think that this is not flexible enough, I'd like to have a table that defines the structure of the report: like one row per subreport, specifying the name and its parameter values. Then the report would be assembled together runtime in a list or something like that, by calling and inserting the subreport by name.

Is it possible somehow?

Upvotes: 0

Views: 133

Answers (1)

Nathan Griffiths
Nathan Griffiths

Reputation: 12756

I can't think of a way to dynamically assemble a report like that without coding something that would generate the required RDL, upload it to the report server and then execute the report.

Another option might be to create one master report with all possible subreports in it. You could then use a table to control the visibility of each subreport, to simulate generating different reports. Obviously you don't want to execute long running queries for subreports that are hidden, so you would have to add a parameter to all your subreports so that if the subreport is hidden the dataset returns no data, e.g.

WHERE
(....) OR (@SubReportHidden = 'Hidden' AND 1=0)

Upvotes: 1

Related Questions