Can Crystal do this?

[HaraldBuesching]

Hey!
My chief wants to do me reports like this:

Customer A:

butter 5 kg
milk 2 l
water 2 l
bread 1 kg

Total Customer A
6 kg
4 l

The only way I could imagine to implement this is to create for each possible unit of measure a new section.

Or is there a possiblitity to do something like this:

Groop 0 Header
Group 1 Header
Group 2 (depending of milk....)
Group 1 Footer
Group 3 (depending of l, kg..=
Groop 0 Header

All help is welcome as usual,
Greetings Harald.

 

[dgillz]

Use a cross tab report - the column is UOM and the row is customer. It lacks a little detail but I'll give you the totals. Post again if this doesn't work.

Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[Ngolem]

Or...place a formula in the details that will add up totals based on unit of measure.

then have display formulas placed in the footer to display the totals of each