Okay I wnat to format my output on the invoice. The invoice has two detail bands - the first shows items sold by project and the second summarizes by item as follows:
Project1 Item1 qty1 price1
Project1 Item2 qty2 price2
Project1 Item3 qty3 price3
Project2 Item2 qty4 price4
Project2 Item4 qty5 price5
SUMMARY by Item
Item1 totqty1 totprice1
Item2 totqty2 totprice2
Item3 totqty3 totprice3
Item4 totqty4 totprice4
This is easy so far. Now I want to group the first detail band by project but NOT group the second detail band.
Project1
Item1 qty1 price1
Item2 qty2 price2
Item3 qty3 price3
Project2
Item2 qty4 price4
Item4 qty5 price5
SUMMARY by Item
Item1 totqty1 totprice1
Item2 totqty2 totprice2
Item3 totqty3 totprice3
Item4 totqty4 totprice4
Any ideas? Thanks in advance.
***************************
Bruce Gilmour
"Two things are infinite, the Universe and human stupidity. And I am not sure about the Universe."
- Albert Einstein