Count data rows by value

b27ipb27ip
edited 11:55AM in FastReport 2.xx VCL
I'm looking for a good example of counting different data values in a master data band. For instance, the Status field could contain values 'green', 'yellow' or 'red'. So I'd like to count the number of instances of 'green', 'red' etc and then display those values in a group footer. Any help would be most appreciated.

Comments

  • EmeraldfrogEmeraldfrog
    edited 11:55AM
    Hi b27ip,

    I hope this idea will help you:

    order by the colour
    the group should be grouped by the Field [qry."Colour"]
    group-footer: 1 field with the "name" [qry."Colour"] of the colour and 1 field [COUNT([QRY."Colour"])]

    Then the footer contains the name of the colour and the counting

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 2.xx VCLComment As ...

© Vanilla Keystone Theme 2024