Group Header Printing for every record

rbuser

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

nicocizik

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.

--