COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: shrini on 26 Jan 2010 05:08:42 AM

Title: Crosstab measures ?
Post by: shrini on 26 Jan 2010 05:08:42 AM
HI Frns, :)

    My problem is when ever i select the measure from value prompt it should be dispalyed automatically on the measure tab in crosstab.


I have placed a textitem and then assigned Source type -- report expression and has kept paramdisplayvalue('msrprompt').But is not displaying for measure tab in crosstab report.So please help me out

Thanks in advance and waiting for reply

Shrini
Title: Re: Crosstab measures ?
Post by: paddhu on 26 Jan 2010 11:49:17 PM
Are you sure, this is not working? I have done what you say and it works perfectly.
First check have you given an expression for the measures. ie. an if-else-if or case statement for the measure expression.
Then you have to unlock the crosstab, select the text item in the crosstab corner cell and change its Source type to Report expression, and give ParamDisplayValue(param_name).