conditional COUNT in FR4

cosacamcosacam
edited 6:44AM in FastReport 4.0
Hi everybody

I have this table

AREA EXPEDIENT NAME SALARY
1 324235 John 1234.45
2 436645 Mary 7843.23
99 346346 Rick 4656.98
etc

I know how to print all records in the table grouped by AREA including a COUNT agregated function in GroupFooter and ReportSummary bands but it counts all records however I ONLY want to count the records which ARE NOT of AREA=99

I've been Googling but to no avail

Sorry for my English
Thanks

Comments

  • gpigpi
    edited 6:44AM
    Use IIF function
    [SUM(IIF(<YourDatasetName."Area"> <> 99, <YourDatasetName."Salary">, 0), MasterData1)]

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

© Vanilla Keystone Theme 2024