Cross Tab - Horizontal Group Field 1

[saran26]

Hi All,

Crystal reports Product Version 11.1

I have a cross tab in my report with Verdict as a horizontal group field and the count of number of tests as the summary field.

The verdict may and may not have any values.

Possible values are

Pass
Fail
Cancelled

and with out any values.

I tried to change the display using the formula to list the ones with out any values as "Not Executed"

formual
if ClearQuest.Verdict = "" then "Not Executed"

But it is not working, please help me out.

Thanks
Saran

 

[Madawc]

Modify the formula:

 if IsNull ({ClearQuest.Verdict})
or {ClearQuest.Verdict} = "" 
then "Not Executed"

Nulls stop everything, unless first tested for with IsNull.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[saran26]

Thanks for the reply...

Saran