Distinct Count Total

Jon PooleJon Poole
edited 1:18AM in FastReport .NET
Lets say I have 5 rows of data with the following numbers
1
2
3
3
4

I want to count the distinct numbers, so the total would be 4 NOT 5. How do I accomplish this?

Comments

  • Jon PooleJon Poole
    edited 1:18AM
    BUMP! --> Does anyone answer anything on these forums or should I just give up and call Tech Support??
    Jon Poole wrote: »
    Lets say I have 5 rows of data with the following numbers
    1
    2
    3
    3
    4

    I want to count the distinct numbers, so the total would be 4 NOT 5. How do I accomplish this?
  • Jon PooleJon Poole
    edited 1:18AM
    Jon Poole wrote: »
    BUMP! --> Does anyone answer anything on these forums or should I just give up and call Tech Support??
    show previous quotes

    I seriously need to know how to do this, any help!!!
  • KeeperKeeper
    edited 1:18AM
    Hi,

    can you give us a little more information on how you retrieve the data? Are you using the RegisterData function with a datatable? Or will the report be directly generated in fastreport?

    Best Regards,
    Keeper
  • KeeperKeeper
    edited 1:18AM
    Hi again,

    see attached file for an example. This is done using FR only. Just an idea, hope you get the idea.

    Best Regards,
    Keeper
  • Jon PooleJon Poole
    edited 1:18AM
    So that is pretty much how I ended up doing it. I was hoping for something a little more like Crystal Reports where I could do it in the sum function.

    I think that the sum function should include such a function in the future.

    Also my data is gathered in the FRX via a MS-SQL statement not pushed into the report.
  • KeeperKeeper
    edited 1:18AM
    Hi,

    sorry, wasn't clear to me, that you already solved it und were just looking for a nicer option. In this case I would suggest opening a ticket and requesting a distinct-count function to fastreport.

    Best Regards,
    Keeper

Leave a Comment


Home • FastReport .NETComment As ...

© Vanilla Keystone Theme 2025