Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: kalyan_y on 27 Nov 2009 12:41:42 AM

Title: Applying Style/Render Variable to a crosstab report
Post by: kalyan_y on 27 Nov 2009 12:41:42 AM
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......
Title: Re: Applying Style/Render Variable to a crosstab report
Post by: vinu on 27 Nov 2009 02:27:33 AM
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
Text only | Text with Images