If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Title Bar going on Next Page

Started by johny.cbi, 26 Jul 2010 04:32:45 PM

Previous topic - Next topic

johny.cbi


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.

mvjcognos

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

johny.cbi

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