Can I use data in a query in the Page Header of a Reporting Services report?

Question

I am pretty sure I cannot, but I would just like to double check - can I use data in a query in the Page Header of a Reporting Services report?

Thanks!

Answer 1

I think this answers my question for me:

SQL Server Reporting Services: Report Header cannot show data fields

Answer 2

You tend to struggle doing this, as i think the header is created before any of the queries have actually been ran, so the data is not available

Answer 3

Hi Dan,

There is a little hack that you can do, although it's long winded. If you create a hidden report parameter that is loaded with the value you want in the header, then you can refer to the parameter (=Parameters!MyParameterName.Value) in the report Header/Footer.

Not great, but if you really need it then this should work.