Questions about grouping and totaling

Fisherman

hey all -

I have a question about a report that I need to write.

I need the following data

From the Item -
Part number, Product Group Code

From the Production Order -
Finished Date
No.
Quantity
Allocated Capacity Need
Actual Time Used

Now - here's the catch - what I need is a report that groups all items, and production of those items, by the Product group code. The user should have the ability to select a date range of production, and a range of Product Group Codes.

What I have created so far is a report that has two data items - Item and Production Order, with Production Order indented under Item and linked on Production Order.Source No. = Item.No (I know I should technically go from Item to BOM and then to Production Order, but our users have elected to have the BOM numbers match the item numbers).

I have required filters on Item and Production Order for my criteria from above. I have Product Group Code specified in the properties for Item as the "Group Total" field. That's where things get sticky...

I need to group the Production order totals within each Product Group Code. I've tried to have this happen, but I've been unsuccessful.

Can anyone think of another way to do this? I can export the .fob to .txt if you need me to.

andreof

To correctly group the data you need 3 steps:

1- create key Product Group Code

2- add Product Group Code to GroupTotalFields property (witch you've done)

3- Use the Groupheader or Groupfooter sections

For totals add the fields you want to TotalFields property

Fisherman

Thanks - I appreciate it.

I've never been good with these designers - I can't see the SQL