GroupFooter shows next record

Tim RTim R
edited August 2019 in FastReport VCL 5
I have the following bands:

GroupHeader
MasterData
GroupFooter

The condition for the GroupHeader is DBXQuery."CUSTID"

I have a SysMemo in the GroupHeader with value
Customer [DBXQuery."CustID"]

I have a SysMemo in the GroupFooter with value
Total for [DBXQuery."CustID"] [COUNT(MasterData1)]

There are 7 records in the table: 4 for customer1, 1 for customer2 and 2 for customer3.

When I run the report I get the following:

Customer customer1 (GroupHeader for first customer - correct)
The 4 records for customer1 generated by the master data band - correct
Total for customer2 4 (GroupFooter for first customer shows the total record count correctly but shows the customer as customer2 not customer1)

The other two groups are similar - ie everything is correct except for the customer ID listed in the GroupFooter.

So to summarise, everything is correct except for the customer ID in the GroupFooter. Although the record count is listed correctly, the customer ID is always the customer ID of the next record, not the current one.

How can I make the GroupFooter show the current customer ID and not the next one please?

Comments

  • Tim RTim R
    edited 9:43PM
    Found a work-around for this problem. I was using DBXDatabase and DBXQuery. Swapped them for IBXDatabase and IBXQuery and it works perfectly.
  • gpigpi

    TfrxGroupFooter needs TDataset.Prior executing. So, DBXQuery will not works correctly

Leave a Comment


Home • FastReport VCL 5Comment As ...

© Vanilla Keystone Theme 2025