Count Unique Values

(2 posts) (2 voices)

Tags:

  1. dharkness, Member

    I have a report that combines parent and child rows in a single table. In the summary row I added the count of each row's PK (autoincrement integer), but I'd like the parent PK column to count only unique values.

    For example,

    Parent  Child
        10     21
        10     22
        11     23
        12     24
    ---------------
         3      4

    Is this possible?

    Of course this doesn't belong to the Installation topic, but I don't see how to move it.

  2. myDBR Team, Key Master

    Easiest way to do it is calculate the distinct count of parent ID's first and then use dbr.summary.text to show it.

    --
    myDBR Team


Reply

You must log in to post.