This means you need to adjust the formula to account for all the possible variables impacting your 4 types, unless you really have 5 types of records that make of the whole record count (complied and 4 types of failed). That changes it a bit. I will need more info on that if that is the case.

Depends on how you want your #'s.

Just add in a copy of your existing report, change the select statement to filter out your other data and your bar chart will automatically adjust. Delete and suppress everything else.

you need a source that has all 4 types listed that you can left join to the failures table (without exploding the record counts). Then you group on the table that has the 4 and it will show a 0 for any where there were no matching records from your failure table. I usually end up doing that in a view or stored proc. and pull that in. It will be a lot more work but that is the premise of how to get it.  One of the tricky parts is that in Crystal, sometimes even though you have aleft join to a table a select statement can pare it down so that your left join ends up acting like an inner join...