there is a table cell above the list report and created a text item(Title Bar) in the table cell. my question is Title bar is repeating in each and every page when I run the report. How to avoid that column(Text item) repeation in all the pages except in the main report page.
take a overall page header or list page header and place ur text item in that then it will show only in the 1 st page
Here is the solution.
Method 1
1. Open the relevant report in Report Studio.
2. Drag a calculation into the Header Block, from the Toolbox - Insertable Objects panel.
3. Select the Type of Calculation as Layout calculation.
4. In the Expression Definition, type the expression as follows:
IF ( PageNumber()=1 ) THEN
( 'This text only displays on the first page' )
ELSE
( '' )
OR
Sloution : 2
Cast the PageNumber() to a string first
if number2string(PageNumber())='1' Then ('Title Reference') Else ('')
Steps:1. Open report studio and build a list/crosstab report
2. Drag a text item to the page header area
3. From the properties, change the Source Type from Text to Report Expression
4. In the report expression definition window, have the above "If Then Else" statement inserted and validate
5. Test run the report