Grouping Records with Identical Data

[TEM3]

Using Crystal Reports 8.5 and Oracle Tables:

I am doing a "Custody" report which tracks the movement of items through the system. Scanning the item to a new location generates several fields of data including the data and time of the tranactions.

Even though we are tracking individual items, items can be group into containers so that when the container bar code is scanned, all the items in the container move identically.

I would like to somehow parse my filtered items and group the activity of items that had the exact same series of custody transactions together. So a report would show:

Items # 1, 5, 7, 8 -

Date Time New Location Transacted By

1/2/05 12:01 xyzqr Jeff Smith
2/5/05 14:56 kjhte Sue Jones

Items # 2, 3 -

etc.

Right now my report lists the activity of each item as a separate line item, even though many items share the exact same custody path.

Any suggestions??

 

[rosemaryl]

Dear TEM3,

Is something stored with each item that indicates it is part of this group? A container id?

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[TEM3]

Yes, exactly. An item in a container has the Container ID field populated in the Item Table. There is also a Container table that can be linked via the Container ID.

 

[rosemaryl]

Dear TEM3,

Group on the Container ID and then on the transaction date.

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762