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

Group Header Printing for every record

edited May 2004 in Subreports
I have a subreport which displays the line items for an invoice. I want
it to group them by parts and labor. I have a boolean field in the
data table for LABOR and set the group to this field. if I enter the
items in the invoice in order of labor and parts the reports looks
fine. All the LABOR is under the labor group header and all the parts
are under the PARTS group header. However, if the items on the invoice
are random as they will invariably be, my report is not grouping them
but is using the order of the dataset and reprints a new Group Header
for each item. I thought that the report engine would take care of the
grouping internally. How can I get this to work, without jumping
through hoops to reorder the dataset prior to printing the report.

--
David Farrell-Garcia
Whidbey Island Software LLC

Posted with XanaNews 1.16.3.1

Comments

  • edited May 2004
    Hi David,

    The RB report engine does not have any logic to manipulate the data in your
    dataset. The report is created as each record is traversed so your data is
    traversed as is. For a group to give the correct output in ReportBuilder,
    you will need to order your dataset based on the group break field.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.