Calculate Checks (PRECHECK Report) Sorting

(0) Share

Report

Posted on by Brady W Riopelle

545

We are seeing an issue where we want to change the sort on the Precheck Report by Lastname, FirstName, then MiddleName. It seems like the sort will work but the issue seems to be when it runs into a duplicate LastName (goes to the secondary sort method). It triggers the report footer to print and then it continues on with the rest of the employees. So the Report totals aren't at the bottom of the report but where the first duplicate lastname is.

Has any come across this issue before or any suggestions?

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (0)

L Vail 65,271 on at

Like (0)

Report

Hi Brady,

I just modified my report to sort like you mentioned. I went into report writer and put in a custom sort by Last Name, First Name, Middle Name. I then created several employees with the same last names, the same last and first names, some with and without a middle name. It behaved perfectly. If you still have a problem, I'll be happy to take a peek at your package file if you want to send it to me.

leslievail@earthlink.net

Kind regards,

Leslie

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi Brady,

The only question I have about your report is whether you want the amounts listed by each customer to represent the receivable net of available discounts or just the base receivable?

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am having the same issue with a client when they modified the Precheck Report to sort by SS#. They have some employees that have their SS # as the Employee ID and that seems to be what is triggering the report totals after that employee. Have you found any solutions to your sort issue?

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

As Lessie said. She has been modified the report with custom sorting options and everything working fine. If you attach the package file of your modified report, this would be helps us resolve the issue.

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the reply. My client has added a sort by the SS#. When they calculate a small batch the report prints with the totals at the end but when they have a full payroll and the report is 400-600 pages the totals print somehere in the middle of the report.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

For small batch report, Is the report print with single page?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No, when I tested it my report was around 30 pages.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi Quinetta,

As Soma suggested, it's really difficult to troubleshoot your report without actually seeing a copy of it. If you will e-mail the package file containing the modified report, I will be happy to look at it. My e-mail is leslievail@earthlink.net

Kind regards,

Leslie

Was this reply helpful? Yes No
srbair 5 on at

Like (0)

Report

Has anyone found the fix for this? I am running into a similar issue.

Was this reply helpful? Yes No
Jim Wilson on at

Like (0)

Report

We need to sort this report and other payroll reports by last name also. Report Writer gives us the problems described. Before we go down the path of creating a custom report just to resolve the sorting issue, wanted to see if there are any alternatives that can be offered by anyone?

Was this reply helpful? Yes No