CR9 SQL DB Printing data with two parameters in only two places 1

[VickieT]

Good Morning

My subject was too long to fit completely so I apologize if it was incomplete.

I am using CR9 against a SQL database (Eden Financial Software)

My customer needs data for Benefit/Deductions of employees insurance premiums for two payperiods each month and totaled so that she can pay the insurance companies.

I have set up two parameters for her to input her payperiod dates (there are always two payperiods that she reports on every month). If I don't give her two parameters and just prompt for the inclusive dates of the two payperiods it prints the data twice for each employee.

Then I have to pull the deduction amount using this formula If {ESYBAMHD.TYPE} = "D" THEN
{ESYBAMHD.AMOUNT}
Else
0.00
I want the deduction to only show in the column of the payperiod it is deducted from then give a total of deductions from both payperiods. This is how it looks:

Name Pay Period 1st PP 2nd PP Benefit Amt

BenDed Code {@amount} {@amount} {@BenAmt}

I am already grouping on Group 1: Bended Code in which I had to create a group which reports on only medical insurance, Group 2: Benefit Amount (Because she wanted them grouped by the different benefit amounts as there are several), Group 3: {@amount} because she wanted them grouped by this as well as there are several differnt amounts, Group 4: is a deduction header formula I wrote that specifies that if a benefit amount is a specified amount and the corresponding deduction amount is a specified amount then put it's proper heading at the top of the group.

Then after it sorts on these groups I am also sorting on last name.

I hope this makes sense but if it doesn't I can provide any more information you need. Thanks so much for your help. You guys are awesome!!

Vickie

 

[MrBillSC]

Vickie,
It sounds like you need your employee (employee-number) to be your 5th group so that you can do a footing at employee-number and place both deduction amounts (one for each pay period) on the same line. To create two deduction amounts, create a formula called PayPer1Ded and set it to the deduction amount if the pay period of the record is equal to the first pay period prompt. Create a similar formula called PayPer2Ded for Pay period prompt 2. Place both formulas in your detail section.Then use the subtotal function for the two pay period amounts in your employee-number footer.

I hope this helps,

mrbill

 

[MrBillSC]

Vickie,
We have Eden software as well. Sometimes it is nice to have connections with other Eden users. Would you like to exchaned email addresses?

MrBill

 

[VickieT]

Hi Bill

Thanks for your response. Yes, it would be great to have another Eden source out there to network with.

Vickie