COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: vinay81 on 02 Nov 2007 07:16:16 AM

Title: Handling Page Header
Post by: vinay81 on 02 Nov 2007 07:16:16 AM
Hi there,

I have report which we run in PDF format now we have requirement to that they want it in CSV as well.

Now problem is i want to hide Page Header when user run it for CSV b;cas in CSV format it gives O/P for 1st query only  :(

Please throw some light on it.

Thanks
Title: Re: Handling Page Header
Post by: rockytopmark on 02 Nov 2007 09:27:18 AM
1). Create a Conditional Block where your header will be.

2). Add a variable that returns True if the ReportOutput() = 'PDF'

3). Set the Conditional Block to use this variable.

4). Set the Condition environment to be in the True state for this Block

5). Put the Header stuff inside this condition of the block.

When the report is putput is PDF you will see the Header objects. and when it is not, there will be nothing in that area of the report.

Tweak the Variable if you want the Header printed in other formats like HTML  (Change = to IN and include all the formats for TRUE
Title: Re: Handling Page Header
Post by: vinay81 on 05 Nov 2007 01:48:59 AM
Thanks for replay...

I think i have not clearly mentioned..

My report having two queries one for Header and other for Page body..
when i run report for CSV format it generate data only for header query..

I want .. when i run report for CSV format it will not consider header query..

Thanks