Skip to Content

How do I populate last record formula value in subreport?

I have a main report and subreport with formula fields.

I am using an employee deduction to display the match number in a subreport.

In this case there is a single record and although the components are not blank, the Match field is.

The calculation is as follows:

If {@Ded%OfSalary (display)} <= 3.00

then round({@GrossPay-Total}*{@Ded%OfSalary (raw)}, 2) else If {@Ded%OfSalary (display)} >= 3.01 and {@Ded%OfSalary (display)} <= 5.00 then round({@GrossPay-Total}*0.03 + (({@Ded%OfSalary (raw)} - 0.03)*{@GrossPay-Total})/2, 2) else If {@Ded%OfSalary (display)} > 5.00 then round({@GrossPay-Total}*0.04, 2);

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers