How to create the condition for Report output in Excel 2007

[jd]

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??

[PRIT AMRIT]

EXCEL

[Lynn]

Here is an easy way to find out!

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

Code Select Expand

'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 :)