Grouping help

[g8orade]

Hi,
I have a report that I am working on that gathers data that will need to export to a spreadsheet for further processing.
Somedays the data detail will change and therfore change some groups to be non-existant. I am trying to figure if there is a way to create the groups that dont have data, and show them as 0 balances therefore keeping my export uniform. I have looked at formulas on the excel side, but for the number of fields that it covers, this would be at best cumbersome. Here is an example of what I am against. And this is a summary report with details hidden.

Dept Type Hours_Worked
1060 G 7
1060 L 15
1060 R 9


Then on the next day it may look like this.

Dept Type Hours_worked
1060 L 6

What I need is for it to look like if there was no data is.

Dept Type Hours_worked
1060 G 0
1060 L 3
1060 R 4

What I trying to accomplish if a group doesnt have any data then it would pad 0s to their group. I know that if there is not details in the detail that this can cause a problem.
Any help or suggestions would be greatly appreciated..
G8orade.

 

[lbass]

What you need is a table that contains all types that you can use as your main table. Then you would use a left join FROM this table to the other table(s). If you then use the type field from this master table, it will always appear on the report.

-LB