Re: Report Filter

Home Forum Reporting Report Filter Re: Report Filter


I think you are saying that you want a report that shows you for each individual employee the value in the balance field from the most recently submitted instance. Correct?

If that is the case, I would use a form connection and a hidden table in my report. Create a connection to your Leave Application form. Send parameter = name, return parameter = Balance, and Name. When the report opens use the connection to populate a drop-down with all of the names in the form instances (leave send parameter value empty). When that drop-down changes data use a Connection to send the name in the drop-down and return the balance to all rows of the table. Then use a Set Table Rows to go to the last row (most recent instance) and finally use a Set Field to set a field in the report with the value in the current row (the balance value from the last instance for that person).

Workflow software, Process software, Procedure software

Do NOT follow this link or you will be banned from the site!