Blank cells in the report without values in the report output

[Divya]

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 so that I can work on them


Thanks a llot

divya

[MFGF]

Hi,

1. Try defining a calculation with the expression if ([Outcome] in ('Good','Bad')) then ([Average]) else (null)
You can then use this as your crosstab measure.

2. It's difficult to give you an approach for this unless you tell us how Timeuntilbreach is stored.  Is it an integer value, or a string, or a date, or an interval, or...?  What format is it currently in?

MF.

[ydeliwala]

for 1. You can create a boolean variable to classify whether the value falls in good & Bad or Worst. Apply conditional formatting by using this variable as text source variable and show output values as blank for rows with 'worst'.

for 2. You can extract the day from the Timeuntilbreach column and use it for an if condition to display the value you want.

Yo!