I have a report where i list the required columns including the approved rejected status of the form submission. The Business User is requesting to narrow the report down to approved requests alone? Is that possible?
Question
Question
Is it possible to design a Report in Forms 10.4 where i can extract only the Approved submissions?
Answer
Yes, what version of Forms are you on? You should be able to add a filter to the report definition to only show the instances at the approval end event.
Replies
Is the status a field on the form? Or an action a user can take on a user task?
I would suggest filtering by the end event. For your approval branch, you should have an end event named something like "Approval End", "Rejection End" for the rejection branch and whatever other end events. You can use a filter on the end event to just get the completed instances that were approved.
The status is the approval on the user task. Yes I have an approval end and rejected end on the status. I see the dropdown where I can pick the field or action.
is there a filter option in the report?
Yes, what version of Forms are you on? You should be able to add a filter to the report definition to only show the instances at the approval end event.
Am on 10.4 forms. Let me check.
Perfect! Was able to set the filter on the Approved end step. Thanks!