Count records based on expression

mavinmsmavinms
in FastReport .NET

Hi i want to display count of records from datasource-table with condition.

For Example: I want to dsiplay count of all records where in table1.column1 city is "usa"


I am not showing any data in data band. I am just creating summary page/statistics page where I need to display only counts and sums based on condition from data-source-table-cloumn.

Comments

  • jurgsterjurgster
    edited October 2021

    Hi,

    Just wanted to join this question. Looking for the answer since I am having trouble grasping the right syntax.

    Text:

    [Gerät."Status".RecordCount()=="Ausgemustert"]

    Current result:

    Field not found

  • jurgsterjurgster

    I beleave to have found the solution, it lays in the syntax.

    For me, this worked:

    [SUM(<Gerät."Status"> = 'Ausgemustert',MasterData1,1)]

    note used quotation mark!

  • CareyCarsonCareyCarson
    edited October 2021

    Oh, I don't know if I'm doing everything right now, but it's not really working for me

Leave a Comment


Home • FastReport .NETComment As ...

© Vanilla Keystone Theme 2025