COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: NiceCube on 17 Jan 2017 10:29:08 AM

Title: Header Rendering in Excel
Post by: NiceCube on 17 Jan 2017 10:29:08 AM
Hi,

Just started a new role with a new company and wondering if there's a setting that allows the report header to be in only one row, when the report's rendered in Excel?

Thanks in advance,

Richard
Title: Re: Header Rendering in Excel
Post by: Lynn on 18 Jan 2017 02:05:42 AM
Quote from: RichParsons on 17 Jan 2017 10:29:08 AM
Hi,

Just started a new role with a new company and wondering if there's a setting that allows the report header to be in only one row, when the report's rendered in Excel?

Thanks in advance,

Richard

You can create a layout that only renders for specific output formats and/or set render variables on specific objects so they render in one situation but not in another. The ReportOutput() function is a report expression that lets you detect the requested output format.
Title: Re: Header Rendering in Excel
Post by: NiceCube on 18 Jan 2017 06:04:05 AM
Thanks Lynn - I'll look it up.