Print Page - [answered] Conditional Blocks Render Regardless of Display?

Title: [answered] Conditional Blocks Render Regardless of Display?
Post by: mikegreen on 20 Feb 2006 02:38:32 PM

Is this still true in MR2/MR3? I have about 16 charts in a report that are displayed based on the users prompt choices. Does it still retrieve the data and take the time to render the chart even if that block is hidden?
I'm thinking it does....?

Cheers,

Mike

Title: Re: [unanswered] Conditional Blocks Render Regardless of Display?
Post by: CoginAustin on 20 Feb 2006 04:02:31 PM

As far as I have seen, yes. On SQL server I have run a Profiler session using one of these reports and found all SQL was ran even if it was not displayed.

Title: Re: [unanswered] Conditional Blocks Render Regardless of Display?
Post by: Kattrix on 21 Feb 2006 07:38:50 AM

With 1.1, it does process the queries even when the block is hidden...
In Cognos 8, there is now an option to turn this off.

Title: Re: [unanswered] Conditional Blocks Render Regardless of Display?
Post by: mikegreen on 21 Feb 2006 07:40:03 AM

Thanks.. confirmed my suspicion.

Cheers,

Mike

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: mikegreen on 20 Feb 2006 02:38:32 PM