One Value (Salary) displays in Detail section multiple times

building reports crystal reports
1

I have an account report that calculates salary, in this report we also show that persons deductions.

The Salary value displays in the detail the same as the amount of deductions that person has.

so if they have 4 different deductions and they make $80,000 a year
in my detail I see this

Salary FICA SS MED Dental
80000 500 0.00 0.00 0.00
80000 000 125 000 000
80000 000 000 200 000
80000 000 000 000 150

How do I get this to show on one row
Also the report is grouped by Company - department - Employee

I’m already selecting distinctly

PB

p_b_bradley :ireland: (BOB member since 2006-03-15)

2

You’re seeing the salary more than once because the query brings it back in each row it pulls. Since you’re pulling a separate row for each deduction, you’ll see the salary more than once. This is the way that database queries work

Depending on how your report is laid out, you can try two things. For either option, right-click on the salary object and select Format Field… and go to the Common Tab.

  1. Check “Suppress if Duplicated”. This will work correctly if each person has a different salary or if two people with the same salary will never be “next” to each other on the report.

  2. If that doesn’t work for you uncheck “Suppress if Duplicated” and click on the formula button to the right of “Suppress” (Do NOT check the checkbox!). Enter something like the following:

{employee group field} = previous({employee group field})

This will suppress the field after the first time it shows.

-Dell

hilfy :us: (BOB member since 2007-04-16)

3

I have done that but I have an additional issue - when i suppress the field it does display but when I try and sum that salary field for a grand total it adds all 4 fields even though they are not displayed

I have multiple employees for each department and I need a grand total of each employee with in those departments - this number is inflated becasue of the multiple record issue.

p_b_bradley :ireland: (BOB member since 2006-03-15)

4

Use a running total for your sums.

  1. Select the field to be summed.
  2. Evaluate on change of group - select the employee group field.
  3. Reset - Never if you want a grand total, on change of a group at a level higher than the employee group if necessary.

-Dell

hilfy :us: (BOB member since 2007-04-16)