I am attempting to edit the Check Register report with Report Writer to group and subtotal direct deposit employees vs. employees who receive checks. Is this possible to do using Report Writer?
I have been going through the Report Writer documentation and I understand that I first need to sort by a field that indicates if an employee is direct deposit or not. The only field I could find that identifies an employee as direct deposit is the check number in the Payroll Work Check table (UPR10208). I added a calculated field that checks to see if the Check Number begins with DD then return 1 else return 0. Is it possible to create a sorting definition with a calculated field? Or is there a better field I can use to sort/group by to indicate if an employee is direct deposit?
*This post is locked for comments