CODEWITHSUNDEEP
sql-server-2005reporting-services
Dan Appleyard
Dan Appleyard

Reputation: 7445

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

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!

Upvotes: 0

Views: 202

Answers (3)

lukehayler
lukehayler

Reputation: 628

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.

Upvotes: 1

beakersoft
beakersoft

Reputation: 2356

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

Upvotes: 0

Dan Appleyard
Dan Appleyard

Reputation: 7445

I think this answers my question for me:

SQL Server Reporting Services: Report Header cannot show data fields

Upvotes: 0

Related Questions