Grouping does not work

anithegregoriananithegregorian India
edited 4:13PM 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 4:13PM
    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

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport StudioComment As ...

© Vanilla Keystone Theme 2024