Question

Detail Section duplicates

Rating6.2Good

I have two tables.
One table has
Order | Employee

another table has
Order | Employee | PaydeductionNbr | TotalDeduction

I have linked the tables through the order and employee.

In the report, i am displaying each employee with their hours, etc. for that order.

In the deductions table, an employee can have many deductions for the same order but i have a formula that will only display deduction if it is a gas.

The formula goes like this:

whileprintingrecords;
if {PAYDED.PAYDEDUCTIONNBR} like "GAS*"
then(
numbervar gas := gas + {PAYDED.TOTALDEDUCTION};
{PAYDED.TOTALDEDUCTION})

The problem is that if the employee has 4 deductions, lets say boots, hat, lunch and gas and i only want to display his gas deduction, it will duplicate the detail  line 4 times and screws up other calculations. one of those lines will include the gas but i dont want to include the rest of the 3 lines.

How do i stop this??

i.e.
Order | Employee | PaydeductionNbr | TotalDeduction
123      5456            GAS                      1
123      5456            Lunch                    1
123      5456            Hat                        1
123      5456            Boots                     1


report will show

123      5456         1
123      5456         0
123      5456         0
123      5456         0

See More

Solution

Access this solution immediately by signing up as a member of CrystalReportsExperts.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.

About this Solution

Sign up Now to View This Solution
Zone
general
Tags
section detail report can duplicate
Participating Experts
2
Solution Grade
B

Replies

 
by: mlmcc

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: repco

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: badstink

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: repco

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by:

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: mlmcc

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: repco

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: badstink

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: repco

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: badstink

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Log In

Forgot your password?Sign up

Stay Connected

Top Experts

  1. mlmcc

    356,274

    Wizard

    0 points yesterday

    Profile
  2. James0628

    80,896

    Master

    0 points yesterday

    Profile
  3. LinInDenver

    4,800

    0 points yesterday

    Profile
  4. peter57r

    4,000

    0 points yesterday

    Profile
  5. 13598

    3,520

    0 points yesterday

    Profile
  6. PCIIain

    1,700

    0 points yesterday

    Profile
  7. RickIsWright

    400

    0 points yesterday

    Profile
  8. Dan3D

    300

    0 points yesterday

    Profile

BrowseAre you an Expert?