hi, in sql server reporting services,i need to display page header in first page only but it is repeating in every page.can any one tell me how to suppress or hide page header in otherpages. Thanks in advance Jayasimha

hii if you want your page header to be shown in first page only its not possible by putting that in the page header as in ssrs page header will be shown in all the pages. So for that you can do like this 1) Put the section whatever is there in your page header (i mean to say what ever you want to show in your page header) in the table header row. 2)in the property of the whole row select "Repeat on new page " to be false again you need to give the visibility condition as some times if your table data is more and its going for the next page then , give the visibility condition as "= IIf(Globals!PageNumber=1,false,true)" hope it will work fine for you anyway let me know if it works for you. Thanks Mahasweta

So why useing a page header if you don't want one?Copy the content of your page header to the upper part of the report body and the cancel the header.HTH,Roy.

Thank you both..... i have shifted all the content from page header tobody section.now it is working fine. Thank you once again. Jayasimha.K

RE : So why using a page header if you don't want one? I think that manylike myself, whoare makingthe transition from Crystal Reports, were spoilt in Crystal because we were used to having a page header AND a report header. IMHO, something Reporting Services is lacking. Paul

I agree. This is a common need, and it is surprising that RS still doesn't support this.DaveB

There are so many thing we want to do, this is one of them.We are in the process of adding support for it in RDL, but I am not sure we will get to adding the UI in Report builder and BIDS this time around....Thierry D'hers [MS]

RE : So why using a page header if you don't want one? I think that manylike myself, whoare makingthe transition from Crystal Reports, were spoilt in Crystal because we were used to having a page header AND a report header. IMHO, something Reporting Services is lacking. Paul Yes, especially when you need to span two columns in a newspaper print layout. I think you need a report header to span these. Surprised that even by Reporting Services 2008 there is no report header, didn't anyone note this from 2005?

There are certain variables that are only available in a header or footer ...Matthew Purtill

Although SSRS does not allow us to use DataSet fields in page headers but it allows us to refer to report items. So we could place a textbox (that takes its value from a DataSet field) anywhere in our report’s body and set its Hidden property to true. Then, we could easily refer to that textbox in the page header with an expression like: =ReportItems!TextBox1.Value and we are done. Note that the textbox that is being referred should be present on every page, or otherwise the header will print empty value.