Skip to Content
0
Former Member
Apr 23, 2012 at 04:42 PM

Grouping difficulty

35 Views

Hi,

I'm wondering if this is possible in Crystal Reports. Here are a couple of sample records:

ID-------IDGroup-------Amount

01-------01--------------$4.00

02-------01--------------$1.00

03-------01--------------$3.00

04-------04--------------$2.50

05-------04--------------$1.50

06-------04--------------$1.00

The "Group" field refers to the ID of the parent item. So the first three items belong together, with ID 02 and ID 03 being child items of ID 01. What I would like to do is set up the grouping in Crystal to be something like this:

--ParentItems (Group Header)

-----Child Items (Details)

--ParentItems (Group Footer)

So in this example:

01------$4.00 (Group Header)

---02------$1.00

---03------$3.00

01 (Group Footer)

04-------$2.50 (Group Header)

---05------$1.50

---06------$1.00

04 (Group Footer)

Is it possible to use grouping or filtering formulas in Crystal to pull off something like this?

Thank you.