Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

Group by Invoice Number and Item... How?

edited May 2006 in Subreports
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

Comments

  • edited May 2006
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2006
    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


This discussion has been closed.