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

Applying Style/Render Variable to a crosstab report

Started by kalyan_y, 27 Nov 2009 12:41:42 AM

Previous topic - Next topic

kalyan_y

Hi All,
I have a report with two crosstabs. Based on the prompt selection(Value prompt with static choices defined), one of the crosstabs need to be displayed on the report.
  I tried using Style Variable/Render Variable/Conditional Block and also Box Type property.
I tried using Boolean Variable/String Variable.

   Can anyone help me in resolving this please......

vinu

Hi Kalyan,

try below.

1.Create a value prompt with required static(2) choices.(Ex:Ctab1 and Ctab2)
2.create a boolean variable with condition.
if ParamDisplayValue('Parameter1')='Ctab1' then 1 else 0
3.Drag conditional block in to work area.
4.select Block and assign Variable to Block variable in Properties pane.
5.Set Current Block from properties pane and set to yes and drag your report1 in to Block.
6.Set Current Block from properties pane and set to NO and drag your report2 in to Block.

Regards,
Venu