Unrelated details without subreports

[xsw1971]

I have a report that is grouped by customer (customer info comes from "TableA".) The detail section of the report lists out equipment used in a billing period, number of days used, the daily cost, etc. The sum of the equipment costs is displayed in the group footer. These details come from "TableB" and are linked to "TableA" using the cust_id in each table.

I would like to add 3 more summary fields in the group footer without showing detail (which is unrelated to the equipment). These new fields are summaries of hours worked by 3 different engineering groups. I don't need to display the dates/times/engineer, just the total for each each engineering group (this will be displayed next to the equipment charges for each customer.) Hours worked comes from "TableC" and is linked to "TableA" using the cust_id in each table.

The only way I can think of getting the engineering totals is to put the hours worked in the details section and suppressing them, but since "TableB" and "TableC" are not related, putting the details of both tables in the same section causes many of the records to duplicate. I tried using a details B section but the records were still duplicating.

Any ideas?

Thanks!
Jennie

 

[synapsevampire]

I think that you're locked into a subreport, or using external SQL.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com