Link to home
Start Free TrialLog in
Avatar of mounty95
mounty95Flag for United States of America

asked on

Crystal Report Crosstab Issue

I have a cross tab report that is based on a SQL view  where inspection results are returned.  An inspection can get a rating of (Superior, Good, Adequate, Not Adequate, Poor).  The report groups the inspections together by municipality.  Not every municipality has poor ratings in their grouping.  I set up a grouping by Specified Order.  I would like all 5 groupings to appear even if there are no records for that grouping.  Is there a setting in Crystal that I can adjust to show all the groupings?  Do I need to modify the view somehow although I can't imagine how?

Any help or light on this matter would be greatly appreciated.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mounty95

ASKER

Thanks for the different perspective.