Report showing all categories (1 Viewer)

[kujospam]

I have a bunch of records that are assigned to categories which are problem tickets. I would like to print the report showing not just the categories that have records open in them now, but also ones that don't have any records in them. So say I have these three categories. Power, Circuit, Hardware failure..If I have a few open tickets in circuit and hardware failures and none in power. Power will show show up on the report but with no records listed underneath it.

Sorry, I did some searching, I just am probably not using the correct search terms. Thank you for any help.

 

[bmal]

If you have a table dedicated to Categories and a separate table dedicated to Tickets with a common field (such as Category_ID), your task is doable by using a join in a query - 'join properties-show all records from Categories....' and then use Totals and do some Count and Group by to get your zero count categories as well as totals for those with entries.