Hi everybody :)
Im back from my vacatino..it was a blast, sunshine and everything. And now im back and getin confronted with several cognos challenges ;)
Heres the situation..
I have one crosstab, with several facts and fact calculations as columns. sth like
Fact 1 Fact 2 Ratio (F1/F2) Fact 3 .....
Row 1
Row 2
What im trying to accomplish is to find a way, to format all values >999 and show "> 999"...as string or as ">" and the number 999.
Ive tried several ways of conditional formatting, but i will need one style for every fact dont i?
I also tried the way of creating a boolse variable and use "Currentmeasure" in my expression, but it didnt work as expected.
Ive found a way using cond. variable and muster, but its quite complicated and i have to set it for every row.
Anybody an idea maybe how to accomplish this in an easy fashion?
Thx and ...nice 2 be back :D
cheerz :P
Charon
A few things to try:
1. How about using a case statement for each column, when the data item is > 999 then display the text '> 999' and for the else condition convert the number to text.
2. Use a case statement to return 999 when the number is greater than 999 then use a variable to conditionally display and greater than image next to the number when the number is greater than 999
As far as I know, the Cognos crosstab does not accept 'text' measures.
This is my way to work around the problem:
Create a boolean variable [ColumnName]Less1000 with expression [DataItem] < 1000 and a boolean variable [ColumnName]More999 with expression [DataItem] > 999.
'Unlock' the report, then select the dataitem in the crosstab and set [ColumnName]Less1000 as the Render variable.
Next, drag a conditional block to the cell of the dataitem and set [ColumnName]More999 as the Block variable.
Set the Current Block property to yes, then add a textitem '>999' to the block.
Set the Current Block property to no again and run the report.
Thx a lot guys, nice ideas. GOnne try them on friday back in the office, il post the result/ solution.
have a nice day :)
cheerz :P