Group by Invoice Number and Item... How?

rbuser

My app creates invoices. Each line item contains an invoice number and item
number.

When payments or adjustments are made, they are posted AGAINST the
invoice/line item. Each CREDIT is tagged with the invoice number and item
number for which it was posted against.

When I generate a statement, I'd like to show the DEBIT and immediately
below it all the CREDITS assoicated for that DEBIT. Then, the next item for
that invoice.

On the statement, I've created a sub-report containing two groups. First by
InvoiceNumber and another by Item number. I've tried placing data fields in
a bunch of ways, but not result in the desired output...

e.g desire output is like this....

Date Description Debit Credit Balance Inv Item
-------------------------------------------------------
10/10/2005 Something 10.00 2.50 1234 1
10/24/2005 Payment 7.50 1234 1
10/10/2005 Something2 3.00 1.00 1234 2
10/24/2005 Payment 2.00 1234 2

nicocizik

Hi Jim,

Looking at your table below, if all these field are available from the same
datasource, your best bet would be to do manipulate the dataset using SQL
code before RB gets it. For instance if you were to order your dataset on
the item number and then by the date, you could stick with one group (on the
item number) and the report should look as it does below.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks for the help. I got it working.

The data is not from the same datasource, so I place a 'filter' on the
subreport as the master changes. It works well now.

Jim