Clarity PPM1

Expand all | Collapse all

CA PPM Tuesday Tip - Conditional Formatting in Jaspersoft

  • 1.  CA PPM Tuesday Tip - Conditional Formatting in Jaspersoft

    Posted 10-06-2015 12:31 PM

    Clarity 14.2 introduced Jaspersoft reporting and the new "ad-hoc" reporting capabilities.

     

    How do I conditionally format a table from an ad-hoc view?

    Trick question, you can't in the ad-hoc view you need to do this in a "report".

     

    So once you have created that ad-hoc view click "Save ad hoc view and create report"

    • Click on report list and find the report you saved
    • Click on the column and from the drop down select the formatting icon
    • Click on the conditional formatting tab
    • Add a condition, then apply formatting as you want
    • Done!

     

    apply_the_conditional_formating.PNG

    End result:

    jasper_conditional_format.png



  • 2.  Re: CA PPM Tuesday Tip - Conditional Formatting in Jaspersoft

    Posted 10-06-2015 12:42 PM

    Thanks for sharing this tip Andy!

    Andy M wrote:

     

    Clarity 14.2 introduced Jaspersoft reporting and the new "ad-hoc" reporting capabilities.

     

    How do I conditionally format a table from an ad-hoc view?

    Trick question, you can't in the ad-hoc view you need to do this in a "report".

     

    So once you have created that ad-hoc view click "Save ad hoc view and create report"

    • Click on report list and find the report you saved
    • Click on the column and from the drop down select the formatting icon
    • Click on the conditional formatting tab
    • Add a condition, then apply formatting as you want
    • Done!

     

    apply_the_conditional_formating.PNG

    End result:

    jasper_conditional_format.png



  • 3.  Re: CA PPM Tuesday Tip - Conditional Formatting in Jaspersoft

    Posted 10-07-2015 12:47 AM

    Thanks for sharing this useful info, Andy

     

    Regards

    NJ



  • 4.  Re: CA PPM Tuesday Tip - Conditional Formatting in Jaspersoft

    Posted 05-24-2016 01:58 PM

    Is there any reason the formatting icon would NOT display? I created a very simple report from an ad hoc view, I am in the report and selected the column and i am not getting the formatting icon, just ascending and descending icons



  • 5.  Re: CA PPM Tuesday Tip - Conditional Formatting in Jaspersoft

    Posted 05-30-2016 03:24 AM

    Hi Serge,

    Most likely you have built a crosstab