Click to See Complete Forum and Search --> : Group in Specified Order


TmpaMike
December 16th, 2008, 09:37 PM
I created an Aging report for a client and i'm having trouble remembering how to do the following. I created a group in a specified order for priority lets use (1,2,3,4) when we run the report it only gives me to totals for priorities (2,3,4) cause for the specified date range there were no priority 1. How can i make it show Priority 1 and reflect 0 as it's total in the group.

DBlank
December 17th, 2008, 01:21 PM
If you have a table that lists all of your priorities options (1,2,3,4) bring that table in and left outer join it in your report. Then group on the priority field from this table.