Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to report on Open vs. Closed records?

Mehernosh Amrol
Giga Guru

I'd like to run a report on Issues in the GRC Module for Open vs. Closed.  I can do this via the Active flag.  Business wants it to say Open for Active and Closed for Inactive.  Is there a way I can change the Label in the report or another way of doing this?

6 REPLIES 6

Allen Andreas
Tera Patron

Hi,

Please see this post (towards the bottom) where people are describing how to change the label like you'd like via data sets, etc.

https://community.servicenow.com/community?id=community_question&sys_id=6a8e7265db58dbc01dcaf3231f96...

Please mark reply as Helpful/Correct, if applicable. Thanks!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Thank you, but unfortunately, I don't have admin role.  I'm trying to do this with the permissions I have.

Hi,

Ok. Please include that information in the future. Thank you!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Community Alums
Not applicable

Hello,

Create your opened report and the press the find_real_file.png icon in the top right hand corner and select "add data set.

From there you will be directed to a new report screen. Create your closed report and press "save data set". This will show both reports side by side.

Please mark as helpful and if its resolved the issue correct!