How do I create a report to show if the approval step was ever declined?

[James Carnes-Dela Cruz]

Hello! 

I am trying to create a report that will show me if a ticket was ever declined during the approval step and can't figure it out. I am trying to call the following: 

"Request Type" = "Transforms Request (GTI)" AND "Approvals[Approvals]" = Declined

but declined is not an option.

I don't have a status in my workflow that changes the ticket status to declined and would really like to report on the number of tickets that have ever had a decline on them as well as the number of times a single ticket was declined. 

Has anyone gotten this to work for them? 

Goal: 

Count the number of tickets that have ever had an approval step = declined AND the number of declines on each ticket

[Mark Higgins · Accepted solution]

Hi James,

No, I don't think you can. As you have discovered you can find items that have been approved(), but not declined.

THinking out-load, you could look at setting a custom field when an issue is declined, and then report on that?

Mark

[James Carnes-Dela Cruz]

Mark, 

Thanks for the idea! I'll try that out.