--- title: "Clarity PPM | Jaspersoft Trick: Add Colored Status Indicators to a Report" description: Add formatting to a saved Jaspersoft report in Clarity PPM (CA PPM), and see colored status indicators at-a-glance. image: https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png --- [![Rego-Logo_Notag-Color-350](https://blog.regoconsulting.com/hs-fs/hubfs/Rego%20Guide%20Images/Rego-Logo_Notag-Color-350.png?width=224&name=Rego-Logo_Notag-Color-350.png)](http://regoconsulting.com) - [Home](http://regoconsulting.com) [![](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png)](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png) # Clarity PPM | Jaspersoft Trick: Add Colored Status Indicators to a Report Today, we'll show you how to add formatting to a saved Ad Hoc Jaspersoft report, so you can see status indicators at-a-glance. In recent posts, we've shown you how to [start your ad hoc report from scratch ](http://regoconsulting.com/start-jaspersoft-reports-fast-ca-ppm/), [email Jaspersoft reports to anyone](http://regoconsulting.com/jaspersoft-trick-email-ca-ppm-reports-to-anyone/), [create an active project report](http://regoconsulting.com/jaspersoft-trick-create-a-ca-ppm-table-report-in-8-steps/), and [create a crosstab report to look at allocations and assignments](http://regoconsulting.com/jaspersoft-trick-create-a-crosstab-report-in-ca-ppm/)in Clarity PPM (CA PPM). Today's step is a powerful ingredient for putting actionable content in the hands of decision-makers. Credit goes to Atul Kunkulol, who shared this trick in [Part 1 of our Free Jaspersoft Webinar series.](http://regoconsulting.com/free-jaspersoft-ad-hoc-webinar/) To get in depth training,[join Rego at regoUniversity in Tempe, April 25-27. ](http://regouniversity.com/) ## Add Conditional Formatting to a Saved Jaspersoft Report To start, go to the Advanced Reporting Home, find the Reports icon, and click on “View list.” This opens up our Repository view, where we can search for a newly created report by name or scroll down to find it. View and change the conditional formatting in a saved Jaspersoft report via Reports > View List Clicking on Reports > "view list" will open up the Report Repository, from which you can select the report you want to format with colored status indicators. Report Repository, Jaspersoft   ## Add Status Colors to a Report One of the things we want to do is highlight projects that are in trouble. We look at that by status. But ad hoc reporting doesn’t really allow that coloring capability in the tables, so we can do that in here. When we open our recently saved report, click on our Status Indicator column, and hover over the table icon, Jaspersoft displays formatting options. Format status and other indicators with colors Choose Formatting. This opens up options for font and color changes. Basic Formatting options for Font Type, Size, Style, Color, and Alignment   If we take a look at the Conditional Formatting tab, there are some fun options. This is where you can pick formatting options based on status. Conditional Formatting to color status indicators Click the “Add” text, enter “On Track” into the Condition box, and choose green from the paint bucket icon. We'll also add a couple more. If it’s “At Risk” let’s make it yellow. If it’s “Critical” let’s make it red, so it stands out. Conditional Formatting for On Track, At Risk, and Critical Projects Once we press okay, the colors are immediately applied to the chosen column, and that's how powerful it is. Conditional Formatting applied to On Track, At Risk, and Critical projects   ## Save a Personalized Report Format If you're not a fan of red, green, and yellow and want to craft something more unique, you can easily make a colorful personal version and save the copy in a personal user folder. Select the disk icon, and choose “Save As.” Use the "Save As" feature to save a personalized report format We can name it Version 2, select the appropriate User folder, and have access to both versions of the report.  Indicate the report is a personalized version by adding a version number ## Tip | Open Source Jaspersoft is an open source solution, so it’s a playground for developers, and there’s lots of development and communities chatting about solutions. While there’s no manual or book yet, Google is a great source. --- It only takes a few clicks to add colored status indicators to saved ad hoc reports in Jaspersoft. It's an easy way to make actionable and personalized reports for both yourself and decision-makers. Join our mailing list below. ### **Let Rego Be Your Guide** Rego also offers [free health assessments](https://regoconsulting.com/clarity-ppm/#health), [webinars,](https://regoconsulting.com/events-ca-ppm/) and [half-day training classes for Clarity PPM](https://regoconsulting.com/free-pm-and-jaspersoft-training/) on Roadmaps in the Modern UX, Power BI, Portfolio Management, and Jaspersoft.  For a full list of Clarity PPM Services, visit [regoconsulting.com](http://regoconsulting.com/).  By [Camille Pack](https://blog.regoconsulting.com/author/camille-pack)|February 14, 2016 #### Share on Social Media - [Tweet](https://twitter.com/share) ### About the Author: [Camille Pack](https://blog.regoconsulting.com/author/camille-pack) ![Camille Pack](https://blog.regoconsulting.com/hubfs/profile%20camille200-2.jpg) Camille Pack has been in marketing for over a decade and started her career as a college composition instructor during graduate school. Technical writing lends itself well to mastery, and in her time at Rego, Camille offered clients product support, configured environments, and served as both a project manager for an internal reporting group and a business analyst for a large external client. Camille holds an MA in Literature and Writing, and a BS in Biology. ### Related Posts ![blog_4_necessities_for_a_pmo_charter_gartner](https://blog.regoconsulting.com/hubfs/Blog%20Images/2018/February/4%20necessities/blog_4_necessities_for_a_pmo_charter_gartner.png) [Permalink](https://blog.regoconsulting.com/4-necessities-pmo-charter) #### [Clarity PPM | Four Necessities for a PMO Charter](https://blog.regoconsulting.com/4-necessities-pmo-charter) February 28, 2019 | [0 Comments](https://blog.regoconsulting.com/4-necessities-pmo-charter#comments-listing) ![upgrading_Blog](https://blog.regoconsulting.com/hubfs/upgrading_Blog.jpg) [Permalink](https://blog.regoconsulting.com/whats-new-in-ca-ppm-clarity-15.5-modern-ux-features) #### [Clarity PPM | Should We Upgrade to 15.5? - Modern UX Features](https://blog.regoconsulting.com/whats-new-in-ca-ppm-clarity-15.5-modern-ux-features) November 05, 2018 | [0 Comments](https://blog.regoconsulting.com/whats-new-in-ca-ppm-clarity-15.5-modern-ux-features#comments-listing) ![regoU-Blog-changes_Linkedin_523x273](https://blog.regoconsulting.com/hubfs/regoU-Blog-changes_Linkedin_523x273.jpg) [Permalink](https://blog.regoconsulting.com/clarity-early-bird-special-register-by-january-31st-to-save-300) #### [Clarity PPM | Early Bird Special at RegoUniversity](https://blog.regoconsulting.com/clarity-early-bird-special-register-by-january-31st-to-save-300) January 24, 2018 | [0 Comments](https://blog.regoconsulting.com/clarity-early-bird-special-register-by-january-31st-to-save-300#comments-listing) ![](https://blog.regoconsulting.com/hubfs/Podcast-episode6-01.jpg) [Permalink](https://blog.regoconsulting.com/the-ppm-podcast-episode-6-davey-zywiec) #### [Clarity PPM | The PPM Podcast: Davey Zywiec on Reporting Strategies](https://blog.regoconsulting.com/the-ppm-podcast-episode-6-davey-zywiec) December 20, 2017 | [0 Comments](https://blog.regoconsulting.com/the-ppm-podcast-episode-6-davey-zywiec#comments-listing) ![](https://blog.regoconsulting.com/hubfs/regU-5-star-01.jpg) [Permalink](https://blog.regoconsulting.com/ca-ppm-clarity-event-is-a-5-star-experience) #### [Clarity PPM | 5 Reasons You Can't Miss This PPM Conference](https://blog.regoconsulting.com/ca-ppm-clarity-event-is-a-5-star-experience) November 21, 2017 | [0 Comments](https://blog.regoconsulting.com/ca-ppm-clarity-event-is-a-5-star-experience#comments-listing) ![](https://blog.regoconsulting.com/hubfs/15_3_blog_header-01.jpg) [Permalink](https://blog.regoconsulting.com/6-things-you-need-to-know-about-ca-ppm-15.3) #### [Clarity PPM | Six Things You Need to Know about 15.3](https://blog.regoconsulting.com/6-things-you-need-to-know-about-ca-ppm-15.3) October 24, 2017 | [0 Comments](https://blog.regoconsulting.com/6-things-you-need-to-know-about-ca-ppm-15.3#comments-listing) [![Rego Home](https://no-cache.hubspot.com/cta/default/2652075/655865ab-5c17-4a7d-8626-9917913749d3.png)](https://cta-redirect.hubspot.com/cta/redirect/2652075/655865ab-5c17-4a7d-8626-9917913749d3) [![Contact Us](https://no-cache.hubspot.com/cta/default/2652075/80445cd5-d730-4608-a09c-dcaaeff582b4.png)](https://cta-redirect.hubspot.com/cta/redirect/2652075/80445cd5-d730-4608-a09c-dcaaeff582b4) ### Subscribe to Email Updates [![Share on Facebook](https://static.hubspot.com/final/img/common/icons/social/facebook-24x24.png)](http://www.facebook.com/share.php?u=https%3A%2F%2Fblog.regoconsulting.com%2Fadd-colored-status-indicators-format-a-jaspersoft-report-ca-ppm%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on LinkedIn](https://static.hubspot.com/final/img/common/icons/social/linkedin-24x24.png)](http://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fblog.regoconsulting.com%2Fadd-colored-status-indicators-format-a-jaspersoft-report-ca-ppm%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on Twitter](https://static.hubspot.com/final/img/common/icons/social/twitter-24x24.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.regoconsulting.com%2Fadd-colored-status-indicators-format-a-jaspersoft-report-ca-ppm%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.regoconsulting.com%2Fadd-colored-status-indicators-format-a-jaspersoft-report-ca-ppm%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=Clarity%20PPM%20%7C%C2%A0Jaspersoft%20Trick%3A%20Add%20Colored%20Status%20Indicators%20to%20a%20Report) ### Recent Rego Articles ### Sign up for our Weekly Newsletter ![rego-logo-white](https://blog.regoconsulting.com/hs-fs/hubfs/rego-logo-white.png?width=205&name=rego-logo-white.png) As the leading PPM, Work Management, and Agile services provider, we have helped hundreds of organizations achieve a higher return on their software investment. ### CONTACT US Questions? We can help. [info@regoconsulting.com](mailto:info@regoconsulting.com) 888.813.0444 ### Stay up-to-date Get the latest news in industry best practices, thought leadership, and software updates. ### Solution Capabilities [Clarity PPM](https://regoconsulting.com/clarity-ppm/) [Rally](https://regoconsulting.com/rally/) [Apptio](https://regoconsulting.com/apptio/) [Sciforma](https://regoconsulting.com/sciforma/) [Jira](https://regoconsulting.com/jira/) [Microsoft | SharePoint](https://regoconsulting.com/microsoft/) [Smartsheet](https://regoconsulting.com/smartsheet/) [Meisterplan](https://regoconsulting.com/meisterplan-itdesign/) ### Quick Links [Our Company](https://regoconsulting.com/our-company/) [RegoUniversity](https://www.regouniversity.com/) [RegoXchange](http://regoxchange.com/) [Careers](https://regoconsulting.com/careers/)   Copyright 2022 Rego Consulting Corporation [Linkedin](https://www.linkedin.com/company/rego-consulting?trk=biz-companies-cym)[Facebook](https://www.facebook.com/RegoConsulting/)[Youtube](https://www.youtube.com/channel/UCdA5xEiDrX--y2nVX2wC1UA?view_as=public)[Twitter](https://twitter.com/regoconsulting) [Privacy Policy](https://regoconsulting.com/privacy-policy/) ![](https://dc.ads.linkedin.com/collect/?pid=14053&fmt=gif)