Master-detail and groups design question

rbuser

Hi,

I have the following design problem:
There is a master table with employee data and detail table with items data.
The tables are connected using a field fldEmployeeCode.
In the detail table there are items, dates and volumes.
I constructed master-detail report. In a main report (data pipeline
Employees) I use group on the employee name. In a subreport (data pipeline
Items, index on employee code, item name and date) I use group on the Item
name. I do not print any details. In Items group footer I print sums for
itmes volume.
Everything works great but my problem is that I would like to have also sums
on dates. So for every employee I want to have the list of items with sums
for every day and sums for every item. Something like a subgroup inside item
group - and only with two tables - tblEmployee and tblItems. Is it possible
to achieve?

Thank you
Janusz

digitalmetaphors

You would create two groups in the Groups dialog box, one on Items and one
on Dates. Make sure that the Items group is first by dragging it to the top
of the list in the dilog. To make sure that the data is organized properly
the query that is retrieving the data has to first sort the data by
employee, then by item, then by date.

--
Cheers,

Alexander Kramnik
Digital Metaphors