Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Studio Questions

Status
Not open for further replies.

geethkal12

Technical User
Jun 16, 2009
17
AU
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
 
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top