Skip to Content
avatar image
Former Member

suppressed if duplicated property ?

Is there a property i can test for "suppress if duplicated property" ?

i have a report, and i have set "suppress if duplicated" . It works fine for formatting and i only get 1 value, but if i total the column, it includes the values for all metrics(plus the suppressed ones).

i want to just total the "first" value that is displayed.

or some other method ??

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 20, 2010 at 08:58 PM

    Suppress if duplicated does just that: it suppresses the record. The record is still on your report - you just can not see it. You could try select distinct in the select expert

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 20, 2010 at 08:40 PM

    You're going to have to create either a running total or a formula to handle this. The easiest may be to create a running total which will be set up something like this in the Crystal Running Total Field wizard:

    Running Total Name: Give it a meaningful name

    Field to Summarize: Select the field that you want to add up

    Type of Summary: Sum

    Evaluate: Use a formula. You'll want to compare one or more key values against the previous record based on what identifies a "unique" record for you in this instance. For example, if UserID and RowDate fields identify a unique record, here's what you would enter:

    {table.UserID} <> previous({table.UserID}) and {table.RowDate} <> previous({table.RowDate})

    Note that this formula evaluates to True or False - you do NOT need if...then True else False! - and the field you've selected will only be added to the running total when this formula is True.

    Reset:If you want the total at a group level, then reset this on change of group. If you want a grand total, then select never. If you need it for both, you'll need to set up two running totals.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded