If you want zero values in a CR crosstab, create a table that just has the column headers in it. Then link to that table doing an outer join. This forces that rows that have zero values to be displayed since the row headers are now part of the result set. The other option is to search Google and there are posts for how to do a crosstab as a stored procedure and you have more control over the data. Then you can just print the results from CR.

I did a search on SQL pivot tables. The first result looks pretty darn good. You can search for more if this doesn't work for.

http://www.sqlteam.com/item.asp?ItemID=2955