How to create a column status rule in a report, for pending approvals

[Jaxelle]

Is there a way to create a status column rule on a report for requests that are pending approval?

I've put in the status rule which equals the status' i want to be highlighted yellow, but how do only the status' that are PENDING THE APPROVAL come up highlighted? I cant' find the option 

Screenshot attached

[Richard_Le_]

Hi,

You'll need a little text mode to achieve this, but it can be done by following these steps:

(1) Go into the report editor, select the status column, then advanced settings and add your formatting rules for the "Compliance request Check" status.

(2) Once your formatting is added, switch to text mode and find the line of code that reads:

styledef.case.0.comparison.righttext=INP

In my code above I have used the "In Progress" status, that has a key of "INP". Yours will have a different key, whatever you set the key as for the "Compliance request Check status"

(3) Add ":A" to the end of the status key (which stands for awaiting approval) and click save. So in my example, the code would look like this:

styledef.case.0.comparison.righttext=INP:A

(4) Save and close the report and you should now find that any requests in "Compliance request Check - Pending Approval" status are formatted per the rules you set earlier.

Hope this helps!

Best Regards,

Rich.

[Jaxelle]

Thanks so much for this helpful breakdown, Rich.

I've followed your steps but it doesn't pull through on my report.

Have I done it correctly? Screenshots attached. 

[Richard_Le_ · Accepted solution]

Hi,

I can see that there are four statuses used in this formatting rule. Should all of them appear in orange when pending approval? If yes, you will need to append ":A" to all of the status codes, so the line of code would look like this:

styledef.case.0.comparison.righttext=HFA:A WJL:A EQB:A VRI:A

Please note that there should be a tab inbetween each status code i.e., HFA:A <tab> WJL:A etc.

Best Regards,

Rich.

[Jaxelle]

That worked!! Thanks as always Rich!