CrossTab with Nulls/Blanks

[sopomeres]

I would like to create a crosstab for showing ethnic races for employees. (Count of employees by race) If a particular race is not represented in our staff, how can I have the crosstab display a blank cell or a '0' (zero)?

Thanks!
Chuck

 

[synapsevampire]

Since there isn't any data for that, Crystal won't fabricate it.

If you had shared your version of Crystal and the database/connectivity used, someone might provide a tailored response.

You might use the table which contains races and Left Outer join it to the current design to provide all races, or create a manual cross-tab in which you hard code in the different races for each formula, which could default to zero.

-k