I am creating a report for a construction company. There are two types of expenses I am interested in. Actual Expenses and Budgeted Expenses. Each Expense type is broken into categories for which I have created a group. For example, Materials Cost, Subcontractor Cost, Permits Cost, etc.

For Actual Expenses, I have each individual expense printing in the details section and then each section is subtotaled in the group footer.

Here is my question. How do I get the Budget Expense type next to the Actual Expense type in the group footer? When I simply drag Budget Expense field next to the calculated Actual Expense field in the Group Summary my report fails and I get duplicate instances of Actual Expenses.

If I am being vague please ask questions and I'll try to be more specific. Any suggestions?

DBlank,
You are correct with your assumptions. The data is in separate tables and budget had not been used in the report until placed in the group footer.

Whereas each group may have multiple line items for actual expenses, budget expenses only has one line item. I am trying to place that one line item for budgeted expense in the group footer next to the subtotaled actual expense.

Could you assist me in writing the formula that looks at which group is the current group, pulls the proper number from another table (based on current group)and places that number in the group footer? I am stumped.

Sample Grouped Data:

Group: Materials Expense
Description   Act Cost   Est Cost
Vendor1        1,000
Vendor2        2,000
Vendor3        3,000
Total            6,000      4,500

There are three items in actual cost that Crystal Sums up to $6,000. The $4,500 is pulled from a table that has three fields; Job Number, Group Name and Amount. It is the $4,500 that I can't figure out how to place into the group footer w/o the report failing.

More details about the report. All reports are based on a job Number. Each job number can have multiple groups. For example: Materials Cost, Subcontractor Cost, Permits Cost and Revenue to name a few.

Thanks for helping with this!



Edited by Joe M - 08 Feb 2012 at 7:48am