A3.153 : Reports : How to design report to sort by employee name

A3.153 : Reports : How to design report to sort by employee name

Question : How to design report to sort by employee name for bank credit report.
Sorting1.png


Solution :

For example, Bank Credit Report.

1) Go to Reports > Payroll Report > Filter report type to Bank Credit Report . Then click on Design button.

Sort2 2.png


2) Click on the Detail1

Sort3 2.png


3) On the right-hand side, expand Data and expand Sort Field.

Click on + button to add new sort field.

Sort4.png


4) Select sort by EmployeeName and set it to be sorted ascending or descending (click on arrow up/down).

Sort5.png


5) Then you can save this report as another format. Click on the following button and then click on Save As button to save to new report name.

Sort6.png

Sort7.png


6) Return to preview report page and click on refresh button then you will see the new report name.

Sort8 2.png


7) Select that report, filter payroll month then click on Preview.

Sort9 2.png


Bank credit report now will sort by employee name.

Sort10.png


--Source from AutoCount Wiki --

    • Related Articles

    • A3.159 : Reports : How to hide employee name in payroll summary report?

      Question : How to hide employee name in payroll summary report (Figure Q.1)? Figure Q.1 Answer : 1. Go to Reports > Management Report > Payroll Summary > Design (as in Figure A.1 ). Figure A.1 2) Select Detail 1 > Behavior > Untick the Visible (as in ...

    • A3.168 : Reports : How to sort payroll summary report by branches?

      Question : How to sort payroll summary report by branches? Answer : 1. Go to Reports > Management Report > Payroll Summary > Design. 2) Click on Detail 1 > Properties > Change to Group Header 1. 3) Click on Group Field > Group By > Change Department ...

    • A3.162 : Reports : How to design subreport in payslip

      Question : How to design subreport in payslip Example : Payslip - B6 Answer : 1. Go to Reports > Management Report > Pay Slip. 2) Select Pay Slip format (Payslip - B6), then click on Design. 3) Double click on the sub-report 4) New tab will be ...

    • A5.45 : How to change Report Font Name and Font Size

      Question: How can I adjust the font name and font size in my report? Answer: To change the font name and size, you would need to amend it at Design Report. 1) To design the report, click Print and click 'Design Report' button on the right side. Click ...

    • A1.151 : Others: Data is not loaded in Report Design

      Question : When I go to Invoice > Report > Design Document Style Report in AutoCount Accounting 2.0, there is no data loaded in Field List. Why? Possible Reason : This is a known bug and fixed in version 2.0.15.145. Solution : Update to Version ...