can v display each conditional block output in different tabs in excel???

[everlearner]

Hi Gurus,

in my page i have 3 conditional blocks, each assigned to diff queries. when i run the report in excel format how would i display
that conditional block output in diff tabs in excel and how to name the tabs??? is it possible?

if possible please let me know the process.

thanks in adv.

[RobsWalker68]

Hi,

Instead of using conditional blocks have a look at using a page render variable.  You would have 1 page per condition that would render if appropriate.  The tab name then becomes the assigned page name.


Rgds
Rob

[everlearner]

Rob Thanks for reply,

could please explain me in detail. i do not have idea in page render variable.
thanks in adv

[Lynn]

There is an entire section in the Report Studio user guide called "Adding Conditional Rendering to a Report" which explains it in detail.

[MFGF]

See here - chapter 13...

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/8.4.1/ug_cr_rptstd.pdf

MF.