break up of a group

[klameer]

Lets say I have a group based on invoice number as

invno tktno amount
1 100 1000.00
1 101 750.00
1 102 500.00
1 103 500.00
2 109 300.00
3 110 950.00
3 111 750.00

lets say I print invoice #1, is it possible to get a break up like this. I cant use the details field

Invoice #1
1000.00 * 1 = 1000.00
750.00 * 1 = 750.00
500.00 * 2 = 1000.00

=======
2750.00

Is this possible?

 

[dgillz]

Group first by invoice and then by amount. Make a maximum summary by amount, which will pull your line amounts out. The no a count by amount which will pull out the 1s and 2s in your example. Then create a formula to multiply them. Hide your details section and group headers.

Let me know if you have any questions. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[klameer]

One small problem is that I cant use the details section in this report because theres a lot I have to put in it for example a pax count which could go up to 5 different combinations. What Im currently doing is putting formulas all over the place. Is this possible in the report header and footer sections?
Thanks dgillz, I really appreciate it