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!

Cross Tab Help

Status
Not open for further replies.

Garyjr123

MIS
Sep 14, 2010
139
US
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
 
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
 
Thanks Ian! That worked. I figured I was doing something minor wrong.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top