Hi
Subject: All Approvals from the approval map to print on GL batch report
I would like to print all the user who approved a document o appear on the batch report
I have joined the EPApproval to the batch table
and put this field value =[EPApproval.ApprovedByID_description]
The first textbox prints correctly the first approver, so the question is how do i get all the additional approvers to print on the report?
Best answer by lauraj46
Hi
The reason that you are only seeing one approver on the report is probably because you are printing the information in the group footer for the batch. Each approver is in a separate detail record and from the footer you can only access one of them.
To fix, I would recommend removing the EPApproval table from your main report and creating a subreport that prints all of the approvers for a batch number. Pass the BatchNbr to the subreport as a parameter. In the subreport you can join Batch with EPApproval just the same as you had in your original schema. That part looks good to me.
Hope this helps!
Laura
+9Hi
The reason that you are only seeing one approver on the report is probably because you are printing the information in the group footer for the batch. Each approver is in a separate detail record and from the footer you can only access one of them.
To fix, I would recommend removing the EPApproval table from your main report and creating a subreport that prints all of the approvers for a batch number. Pass the BatchNbr to the subreport as a parameter. In the subreport you can join Batch with EPApproval just the same as you had in your original schema. That part looks good to me.
Hope this helps!
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
