is there a way to create a cross tab and take out the null values

[jschill2628]

Is there a way to create a cross tab with five fields, and make sure that the cross tab is not capturing the null values?

For example right now, I have identified the null values as “not yet Classified” from the below formula.

if isnull ({IRSCLAIM.SPECIAL23}) then "Not yet Classified" else {IRSCLAIM.SPECIAL23}

Is there an easy way to pull the "Not yet Classified" out of the cross tab?

 

[lbass]

You need to explain how tables are joined, and also explain the exact set up of the crosstab (in the expert). Then explain what results you are getting that you don't want to get. If you are using formulas in the crosstab for row or column fields, please show the content of the formulas.

-LB