Add textbox to show Max subtotal???
See PDF example...
How can I get Employee Billy Johnson to show on one line with a total of 1.25? (0.5 + 0.75 = 1.25)
I need to merge the two lines and only show something like this:
Division Manager Billy Johnson $44,174.60 1.25
I don't know if this will help:
SQL behind the report:
SELECT BRANCH.Branch, EMP.EmployeeName, EMP.Salary, EMP.Active, DIVPAY.PCB, DIVPAY.PayIncrease, BRANCH.BranchID, ROLE.Role, ROLE.RoleID, ([Salary]+([Salary]*[PayIncrease]))+(([Salary]+([Salary]*[PayIncrease]))*[PCB]) AS TEC, INSTRUCTOR.Utilized
FROM (ROLE INNER JOIN ((DIV INNER JOIN (BRANCH INNER JOIN EMP ON BRANCH.[BranchID] = EMP.[BranchID]) ON DIV.[DivID] = BRANCH.[DivID]) INNER JOIN DIVPAY ON DIV.[DivID] = DIVPAY.[DivID]) ON ROLE.RoleID = EMP.RoleID) LEFT JOIN INSTRUCTOR ON EMP.EmployeeID = INSTRUCTOR.EmployeeID
WHERE (((EMP.Active)="Active"))
ORDER BY BRANCH.Branch;
Thank you,
Lynda
See PDF example...
How can I get Employee Billy Johnson to show on one line with a total of 1.25? (0.5 + 0.75 = 1.25)
I need to merge the two lines and only show something like this:
Division Manager Billy Johnson $44,174.60 1.25
I don't know if this will help:
SQL behind the report:
SELECT BRANCH.Branch, EMP.EmployeeName, EMP.Salary, EMP.Active, DIVPAY.PCB, DIVPAY.PayIncrease, BRANCH.BranchID, ROLE.Role, ROLE.RoleID, ([Salary]+([Salary]*[PayIncrease]))+(([Salary]+([Salary]*[PayIncrease]))*[PCB]) AS TEC, INSTRUCTOR.Utilized
FROM (ROLE INNER JOIN ((DIV INNER JOIN (BRANCH INNER JOIN EMP ON BRANCH.[BranchID] = EMP.[BranchID]) ON DIV.[DivID] = BRANCH.[DivID]) INNER JOIN DIVPAY ON DIV.[DivID] = DIVPAY.[DivID]) ON ROLE.RoleID = EMP.RoleID) LEFT JOIN INSTRUCTOR ON EMP.EmployeeID = INSTRUCTOR.EmployeeID
WHERE (((EMP.Active)="Active"))
ORDER BY BRANCH.Branch;
Thank you,
Lynda
Attachments
Last edited: