Report Studio Questions

[geethkal12]

Hello All,

I have two queries with me.

1. In a crosstab Report there is average in the crosstab corner and display date in the rows area and Outcome in the column area. for the outcome I have given a case statement and segragated as GOOD Bad and worst. In the report output I want to get the figures for GOOD and BAD but not for WORST. The worst cells should be blank in the report output.

Please suggest me how to get it done in the cognos report studio as it is very urgent


2. There is one data item called Timeuntilbreach in my list report.
I have to get that data in the report output as follows
if it is less than one day it should be displayed as HH:MM
if it is greater than one day it should be displayed as DD:HH


Please give me ideas asap so that I can work on them


Thanks a lot

divya

 

[EIMTech]

Divya,

Below is my suggestion.

For 1.
Create a Conditional variable for worse.
e.g. if value < 0 then
1
else
0
then use that conditional variable for conditional formating for crosstab value cell and if variable value is 1 then set foreground color to white.

For 2.
You can use conditional format for this too. you just need to change the data format for cell.

Good Luck.
Gyan