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

Group Header in mainreport dependant on Subreport set global

edited January 2004 in Subreports
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.

Comments

  • edited January 2004

    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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.