Group Header in mainreport dependant on Subreport set global

rbuser

Rb7.02 D6 End User reporting.

I have a report that has a sub report in the detail band. It sets a
global variable gnPercentile.

I have a custom field group on a variable in the main report that has
an on text event that uses gnPercentile to display one of four
strings.

It mostly works except the group break happens AFTER the detail row
prints. That is, the first row of what should be group2 prints at the
end of group1 instead.

I get:

Header gnPercentile >90
detail 99
detail 95
detail 87

Header gnPercentile 80-90
detail 85
detail 84


I want:

Header gnPercentile >90
detail 99
detail 95


Header gnPercentile 80-90
detail 87
detail 85
detail 84


Is there anyway around this?

Thanks,
Rick Matthews
Dartek Systems Inc.

nardmoseley

Grouping on a cutom field is tricky, due to the timing of when the report
engine checks for a group break.

Try moving the group from the main report to the subreport. Then in the
OnGetText event reference the DataPipeline[] field values directly rather
than relying on a calculation.


--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com