Consolidate like items after group sort

[PH111L]

My verbage may be off a little or a lot but will try to explain as best as I can the need! TIA for answers!
Crystal 8.5
Left join Group sort

We group by field {WBS1}

Field {WBS1} data contains lines of like data where if several of the lines fields match I want them to consolidate and show a single entry with a summed "quantity" where we would normally see many of the same line items but each with a different quantity.

I have achieved this in the past by a custom formula named sortconsolidate:
{tblcrystalwbs.COSTREF} + ToText ({tblcrystalwbs.UNITPRICE}) + {tblcrystalwbs.TYPE} + {@Units} + {tblcrystalwbs.DESC}
Then Group by the formula, and it just consolidates and works.

But I cant seem to get it to Group by the {WBS1.field} and then sort by the formula/consolidate...

I am stumped I can do either/or but not both!

Any ideas?

Phil

 

[synapsevampire]

Try supplying technical information:

Crystal version
Database/connectivity used
Example data
Expected output

If you're using formulas, supply what's in them (such as {@Units}).

And this "Field {WBS1} data contains lines of like data where if several of the lines fields match I want them to consolidate " means that you want to only display one line if there are dupes, or only when there are several, and how many is several?

Groups are always sorted, so I'm at a loss for what a group sort is as well.

I would suggest that you group on the field, and then place all of the fields in the group footer, and suppress the details.

Now drop the field to sum into the details, right click it and select insert summary->sum and select the group as the sum area.

Now you can place your formula in the group footer.

Hopefully this resolves, and in future posts you'll find that technical information goes a lot further than a text description of a requirement.

-k

 

[PH111L]

Though I struggled at first with the answer, after sleeping on it, and rereading this morning I made it work, Thanks for your help!

Phil