I need to include the name of the last approver in a report as per the customer's requirement. To achieve this, I am using the EPApproval DAC. I sort the records in descending order of the ApprovalID field, which ensures the first record corresponds to the last approver. From this record, I need to retrieve the approver's name and display it in the report. Could you guide me on how to fetch the approver's name effectively and ensure it appears correctly in the report?
Best answer by lauraj46
Hi
To print the Approver name, you can use the field ApprovedByID_description.
With your data sorted in descending order, place the approver name field in the group header section. Alternatively, you could sort in ascending order and print the name in the group footer.
Hope this helps!
Laura
+8Hi
To print the Approver name, you can use the field ApprovedByID_description.
With your data sorted in descending order, place the approver name field in the group header section. Alternatively, you could sort in ascending order and print the name in the group footer.
Hope this helps!
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
