« previous next »
Pages: [1]

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

Offline mikegreen

  • Community Leader
  • *****
  • Posts: 141
  • Forum Citizenship: +3/-0
[answered] Conditional Blocks Render Regardless of Display?
« on: 21 Feb 2006 02:38:32 am »
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 »
Logged

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.
Logged

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.
Logged

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
Logged
Pages: [1]
« previous next »