I have a board that I need to show a breakdown of the total gifts made
by each board member by fund type ( unrestricted, restricted). I can do
this in a cross tab report, but it only shows those that have made gifts
and omits those without gifts. How can I get  them all to show whether
they have given or not?

The problem is that the value is NULL, not the zero that you are expecting.  Null values are automatically excluded from crosstabs.  In the report options, you can convert Null values to the default for the field type.

Another option is to create a formula using the IsNull() function to output a zero when the value is null.

If you are using Crystal XI, you will also need to make sure that you are using a LEFT OUTER JOIN to the gift table.  The default is an INNER JOIN.

Drew

Hi Drew - I did select "Convert Database NULL Values to Default" and changed the link to my particular table from an inner join to a left outer join but still haven't had any luck.  I've also tried enforcing the link in various directions but this hasn't worked either.  Am I missing a step?  Thanks!

Tom

Hi Therese

Try looking into the access database, the board members might not have even gotten exported if they did not meet the criteria set. So if the data is not there it will be difficult to show in the crosstab. You could write a formula to list all the board member names and use that in the cross tab though.

Ray