Is there a way to put subreports in headers in SSRS?

Question

Every time I use a Microsoft product I feel like I'm delving deeper into some form of existential mental masochism. However, I'm forced to use the tools the company buys, anyway...

I would like to use a sub report, since it gets used on many reports, in the header. However, sub reports won't go into the header and neither will field values. Although, parameters will go just fine. (Seriously, who put this together?)

Any suggestions or references for how to bypass this?

Answer 1

Hi,

I approcahed this the other way.

Created a report which just contained a header and a footer.

Then for every report we need we just created a sub report.

I know it isn't anywhere near perfect. But it worked for our reports.

Another option is to create an assembly which pumps data into a field in the header. Works fine if there's nothing too graphical in the header...