Selection records/formula editor

[jsantelli]

I need to create a report that will display a deduction amount for one, two, or both deductions that an employee has - each deduction must be in a separate column. If I use select expert to select that the deduction is one of the two, then it only returns records for the first deduction code found and not the second. Because it varies whether each employee would have one, two, or both deductions, I am puzzeled as to how I can get this information out of the report.

Subreporting the information would not export it correctly. Any ideas?

 

[dgillz]

How do you determine if an employee has one, the other, or both deductions? Is there a field that states this? Please explain your database structure.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[lbass]

What are you trying to accomplish with this report? Why are you selecting specific deductions, i.e., what records are you trying to exclude?

-LB

 

[Ngolem]

This place is never short of ideas....

But we often lack the information to make them....your situation is a case in point.

We are not supposed to plan a report for you...but we can advise the best way of accomplishing what you want to do.

Give details of the data tables available, Crystal version you are working with and a picture of what you want the report to look like....along with restrictions on the data as was pointed out earlier.

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!