COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: k2 on 16 Apr 2013 09:02:47 AM

Title: Hiding Report Footers in Excel but not in HTML/PDF
Post by: k2 on 16 Apr 2013 09:02:47 AM
Hi there,

I am having an interesting requirement for a Report Studio Report. Some of you many have done this earlier!

I have to create a report which should hide Report Footer when the report output is in Excel but the report output should be visible in HTML/PDF format. All your valuable suggestion will be much appreciated.

Kindly let me know if any further information is required. Cheers
Title: Re: Hiding Report Footers in Excel but not in HTML/PDF
Post by: RKMI on 16 Apr 2013 10:31:24 AM
Hi,

You can duplicate the same page and use render variable. With this type of case as follows,

CASE
WHEN ReportOutput () = 'HTML' THEN 'HTML'
ELSE 'PDF'
END

Then on Html output selection it will display the pages with html true variable else the other.

Thanks,
RK
Title: Re: Hiding Report Footers in Excel but not in HTML/PDF
Post by: k2 on 17 Apr 2013 09:17:40 AM
Thanks RK for your valuable comments. It works!!! Cheers