Basically you need to add a row of data for each state for each column that is 0, or something like that. If you are connecting to directly to the tables in the database, this is going to be difficult, as what you really need to is 'create' data, and this is not Crystal's forte. If you get the data via a stored proc, you should be able to do an outer join....
Do you have a 'states' tables? If so, you can probably do an outer join to it in Crystal, this will 'create' the extra rows that you need.
HTH
IP Logged
