Grouping does not work

anithegregoriananithegregorian India
edited 11:37PM in FastReport Studio

I created a report for learning FR and found that grouping doesn't work.

The bands are also inserted in correct order. Here's a list of sequence of bands placements:
1st Band [ReportTitle]
2nd Band [PageHeader]
3rd Band [GroupHeader] which is grouped by ADOQuery1."GName"
4th Band [MaterData1] where the fields are placed
5th Band [GroupFooter] for aggregated summary details
6th Band [PageFooter]

See the TXT exported report below:

GROUP NAME : CHEMICALS
CHEMICALS CHEMICAL REAGENT
GROUP NAME : HARDWARE
HARDWARE REACTOR VALVLES
GROUP NAME : CHEMICALS
CHEMICALS RAW MATERIAL FOR NEPTHANE
GROUP NAME : RAWMATERIAL
RAWMATERIAL SURGE ADAPTERS

Notice the CHEMICALS group -> (which is not actually grouped but goes beyond the group and a new group is created for it) I've been pulling out my hairs all day to find out why this happened

Comments

  • MrSpockMrSpock
    edited 11:37PM
    Hello anithegregorian,

    what is the SQL Statement in the query? I guess that you have not sorted the data using the ORDER BY clause.

Leave a Comment


Home • FastReport StudioComment As ...

© Vanilla Keystone Theme 2025