Author Topic: [answered] Conditional Blocks Render Regardless of Display?  (Read 698 times)

Offline mikegreen

  • Community Leader
  • *****
  • Posts: 141
  • Forum Citizenship: +3/-0
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
« Last Edit: 21 Feb 2006 07:40:21 pm by mikegreen »

Offline CoginAustin

  • Community Leader
  • *****
  • Posts: 189
  • Forum Citizenship: +10/-0
Re: [unanswered] Conditional Blocks Render Regardless of Display?
« Reply #1 on: 21 Feb 2006 04:02:31 am »
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.

Offline Kattrix

  • Full Member
  • ***
  • Posts: 10
  • Forum Citizenship: +1/-0
Re: [unanswered] Conditional Blocks Render Regardless of Display?
« Reply #2 on: 21 Feb 2006 07:38:50 pm »

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.

Offline mikegreen

  • Community Leader
  • *****
  • Posts: 141
  • Forum Citizenship: +3/-0
Re: [unanswered] Conditional Blocks Render Regardless of Display?
« Reply #3 on: 21 Feb 2006 07:40:03 pm »
Thanks.. confirmed my suspicion.

Cheers,

Mike