Group problem

rbuser

Hello!

There is a table i want to build a report from. I need to group it by VOID
(contains 0 or 1 only) field. I've created a group on this field, put DBText
on Group header and some DBText(s) on detail band. But the report looks like

VOID: 1
detail data A
VOID: 0
detail data B
VOID: 1
detail data C
VOID: 0
detail data D

Why it's duplicated? And why detail data A is different from detail data C?

Good luck, Serge

digitalmetaphors

You need to sort the dataset. The group on RB will not reorder the data for
you. The group in the report is used to set the group breaks when the
datafield changes value while the data is being traversed by the report.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

The dataset was sorted by VOID field. The same result.

digitalmetaphors

Take RB out of the picture. Drop a DBGrid on the form and connect it to the
datasource. What does the data look like? If the group break value strings
are different from one record to the next, then RB breaks to a new group.


Cheers,

Jim Bennett
Digital Metaphors