Count with condition if text='xxx'

sangesange
edited 2:47PM in FastReport 3.0
i'm new try fr,
i have data like this,

period ket
1 libur
2 libur
3 libur
4 kerja
5 kerja
6 libur

how can i get count of "ket" for libur = 4, keja = 2 in footer

thanks

Comments

  • ShivanShivan Germany
    edited 2:47PM
    Hi,

    I think you have to do this either via SQL or via scripting.

    In script you have to create a variable/stringlist for example and there count your values.
    If mystringlist.names.indexof('..') = -1 then add a new row
    else increase your count by increasing mystringlist.values[yourindex]

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 3.0Comment As ...

© Vanilla Keystone Theme 2024