COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: everlearner on 03 Dec 2012 07:19:39 AM

Title: can v display each conditional block output in different tabs in excel???
Post by: everlearner on 03 Dec 2012 07:19:39 AM
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.
Title: Re: can v display each conditional block output in different tabs in excel???
Post by: RobsWalker68 on 03 Dec 2012 07:48:29 AM
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
Title: Re: can v display each conditional block output in different tabs in excel???
Post by: everlearner on 03 Dec 2012 08:15:10 AM
Rob Thanks for reply,

could please explain me in detail. i do not have idea in page render variable.
thanks in adv
Title: Re: can v display each conditional block output in different tabs in excel???
Post by: Lynn on 03 Dec 2012 08:20:53 AM
There is an entire section in the Report Studio user guide called "Adding Conditional Rendering to a Report" which explains it in detail.
Title: Re: can v display each conditional block output in different tabs in excel???
Post by: MFGF on 07 Dec 2012 08:46:19 AM
See here - chapter 13...

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

MF.