Print Page - How to create the condition for Report output in Excel 2007

Title: How to create the condition for Report output in Excel 2007
Post by: jd on 18 Mar 2011 10:05:42 AM

Hi I have report with two blocks.

In 1st block have a list and when I run my report in html/pdf this list has to show.

In 2nd block I have a list and when I run report in excel 2007 this one only needs to show up.

for that what I did for 1 st block I created a render variable like
reportoutput() in('PDF','HTML')

for excel 2007 what should be the reportoutput()=

please any one can help me??

Title: Re: How to create the condition for Report output in Excel 2007
Post by: PRIT AMRIT on 18 Mar 2011 11:35:34 AM

EXCEL

Title: Re: How to create the condition for Report output in Excel 2007
Post by: Lynn on 18 Mar 2011 11:37:13 AM

Here is an easy way to find out!

Drag a layout calculation onto a simple report page. Use this expression:

Code Select

'Report Output is: ' + ReportOutput ()

Now run the report in any output you like and see what it is!! I'd tell you but I hate to spoil the surprise :)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jd on 18 Mar 2011 10:05:42 AM