this works when the employee has both Type 1 and Type 2 deductions, but if there is only 1 particular ded per ded code/employee, I seem to lose the amount and it shows as nothing.
ie.
EmplId Ded Cd PayEnd Dt EmplyeContr EmplyrContr Curr Ded DedType
1000 S100 2010/09/09 0.0 25.00 10.00 2
1000 S100 2010/10/09 0.0 15.00 12.00 2
1000 S100 2010/09/09 15.00 0.0 10.00 1
1000 S100 2010/10/09 10.00 0.0 8.00 1
The above works, curr ded shows as 20.00 in Group2 footer
1010 S100 2010/09/09 15.00 0.0 10.00 1
1010 S100 2010/09/15 15.00 0.0 10.00 1
1010 S100 2010/10/09 15.00 0.0 10.00 1
The above doesn't work, curr ded shows as nothing istead of 10.00
I created RTs for Type 1 and Type 2 curr ded and on the Formula field I put
If {#EE_Curr_Ded} > 0 And {#ER_Curr_Ded} > 0 Then {#EE_Curr_Ded} + {#ER_Curr_Ded} Else If {#EE_Curr_Ded} > 0 Then {#EE_Curr_Ded} Else If {#ER_Curr_Ded} > 0 Then {#ER_Curr_Ded}
I am still getting nothing in Group2. I want to see 10.00, it still works when the empl has both 1 and 2 type.
When I display the #EE_Curr_Ded and #ER_Curr_Ded in Group2 footer, it displays 10.00 in #EE_Curr_Ded. Why is the formula not working ?
I am on version 9. Is it possible that it's somewhere else ? Is it some kind of a tab called pick list ? I am using Crystal Syntax or does it matter ?
The only thing I see is under File>Options - under When reading data, check box for either Convert Database NULL Values to Default or Convert Other NULL Values to Default.
There is also under File>Report Options>General Settings - check box for Convert Database NULL Values to Default and another one for Convert Other NULL Values to Default.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
