How to create a SSRS showing the list of terminated employees?

Finance and Operations/AX Technical Forum
1

Our client needs a report that shows the list of terminated employees. How should i proceed??

2

Dear mriganka,

First of all there is no table to maintain the terminated employees.

You better customize new table and form which maintain all terminated employee records.

In clicked method of terminate button in Worker form,write a code to insert the employee records in the customized table.

Then you can use the customized table for SSRS Report development.

Thanks & Regards,

Britto John Baskar.A

3

Mriganka,

Use the EmplTable in AX. There is an field on that table called ‘status’ for active / inactive employees and you will use the status field (which uses an enum) label ‘Terminated’ in your report as a hidden parameter so that only terminated employees are returned.