If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Empty variable as default

Started by jonnyc, 24 Sep 2014 11:54:31 AM

Previous topic - Next topic

jonnyc

Hi

I am trying to create a report with the following structure:

Static Repeater table to set variable1 Connected to Data Deck.
Data deck has a Chart and a Crosstab with master detail relationships to the data item. 
No default items are selected

The problem we have is that on running the report the chart/crosstab are already filtered to one of the data items.  The variable appears to be empty.  We would want all of the data item members to show until the user selects one of the values from the control.  I have played with the 'Drop this condition if the variable is empty' checkbox on the data deck container select with no effect.

I appreciate any and all ideas.

Thanks much

MFGF

Quote from: jonnyc on 24 Sep 2014 11:54:31 AM
Hi

I am trying to create a report with the following structure:

Static Repeater table to set variable1 Connected to Data Deck.
Data deck has a Chart and a Crosstab with master detail relationships to the data item. 
No default items are selected

The problem we have is that on running the report the chart/crosstab are already filtered to one of the data items.  The variable appears to be empty.  We would want all of the data item members to show until the user selects one of the values from the control.  I have played with the 'Drop this condition if the variable is empty' checkbox on the data deck container select with no effect.

I appreciate any and all ideas.

Thanks much

Hi,

The issue here is that only one card of a deck (or data deck) can ever be visible to the user. What you are seeing is simply the first card for the first data value. It isn't being driven by the variable - it's just the card that happens to be at the top of the deck.

What you need to do is to select your data deck and enable the Default Card property - this is an extra card that gets displayed when no variable values are set. You can drag a new chart and a new crosstab to this Default Card showing all the data values.

Cheers!

MF.
Meep!