Saturday, February 25, 2012

Report Headers

I'm new to Reporting Services, but am familiar with other reporting tools. My question is, is there really no way to reference a field in a page header? If so, I suppose you could repeat some header information on subsequent pages from the detail section of the report using a text box, but how is that done because when I check the property box "Repeat report item with data region on every page" nothing happens. What is the best way to repeat header information on every page that needs to contain field values/information?

Thanks for any help you can offer.

Referencing a field from page header/footer is not supported currently. When you set a textbox to repeat on each page, you need to pick a data region for the textbox to repeat with. Suppose you have a table that'd span multiple pages, set the data region to the table. Or you can select the table header/footer row, and set it to repeat on each page.|||

You can use a field in the report header. Drop a field in the report body and make it invisible, if you don’t need it in the report body. Then drop a textbox on a header and type =ReportItems!TextboxName.Value (The textboxname is where your field is in the body)

Regards

|||

Thanks, GNDSP, but this solution seems to be unsuitable when the data you need repeated on each page comes from a different data set.
What do you do if the data being shown in the report body comes from a different data set than the header text?

I hope the next version of RS fixes this limitation of repeating data on multiple pages, as well as introducing a better way of integrating reports with your own code... the current "Code" tab in the report properties dialog box only supports Visual Basic and is hardly a suitable code editing window... how about "Code Behind" for reports, that also supports C#?

Thanks

Graham

No comments:

Post a Comment