Crystal Report Cross Tab

[Tubby6]

Hello I am looking to create a cross tab based on the following
1. The count on items that do not have a particular item.

I was able to get the count on a field that did have information, BUT NOT ON THE COUNT THAT DID NOT HAVE INFORMATION.

so i want a cross tab that displays the number of tickets that did not input anything in a particular field.

I started the following

If {HPD_Help_Desk.Generic Categorization Tier 1}<> "Capacity, Human Error"
Then
isNull {HPD_Help_Desk.Generic Categorization Tier 1}
Else
True

But i do not think this is correct. Is null is supposed to give me the an expression that contains NO valid data....

Can anyone help?

-Tubby

 

[lbass]

You need to check for nulls first, so you could use a formula like the following in your crosstab:

if isnull({HPD_Help_Desk.Generic Categorization Tier 1}) then
"No Data" else
{HPD_Help_Desk.Generic Categorization Tier 1}

-LB

 

[Tubby6]

I tried this .. but it prompts me that a boolean is required...

If isnull({HPD_Help_Desk.Generic Categorization Tier 1})
then
"No Data"
else
{HPD_Help_Desk.Generic Categorization Tier 1}

your help is greatly appreciated
tubb

 

[lbass]

You should be creating this in the field explorer->formulas->new, not in the record selection formula area.

-LB

 

[Tubby6]

success! you are brilliant.