Cross Tab Help

[Garyjr123]

I have inserted a cross tab that I would like to have show total number of specialties listed in the report. When I add the cross tab with column formula:

if {resind.class} = 'KAISER' then {service.abbr} else
if isnull({resind.class}) then " "

and

row info: count {appt.appt_id}

I get a result in my table where the specialty (column) is blank and the count is in the hundreds.

Total
Total 278
(blank) 248
Ortho 13
Oto 8
Uro 9

I do not want the blank specialty with 248 showing up when the actual results returned on the report are Ortho 13, Oto 8, and Uro 9. I am not sure what I am doing wrong. The true total should be 30.

Thank you,

Gary

 

[IanWaterman]

You must deal will NULLS first in any Crystal formula otherwise it fails.

if isnull({resind.class}) then " " else
if {resind.class} = 'KAISER' then {service.abbr}
else .....

YOu also need to tell i what to do if {resind.class} <> 'KAISER', at present this will return a null and may be contributing to your blank count

YOU can filter out Nulls in select expert by adding the clause

and (not(isnull({resind.class})))

This should reduce your blank count too.

Ian

 

[Garyjr123]

Thanks Ian! That worked. I figured I was doing something minor wrong.