geethkal12
Technical User
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
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