Forum Discussion

Oscar's avatar
Oscar
Contributor
3 years ago

Dashboard Report Style

Happy New Year Everyone!

I am hoping someone has an example of how to use the formatting rule in OneStream Dashboard Reporting to change the style of any row in table oContent where label13 (field OFCvRAVAR in my dataset) is not zero. I think it's also possible via a script ... Have been looking in Golfstream for an example, but no luck. Thanks!

Reports
  • Oscar's avatar
    Oscar
    3 years ago

    Yes I can ... I think I stumbled upon the solution ... I will document below in case anyone needs help with conditional formatting. 

    Create a Formatting Rule and assign a condition (and required formatting). In my case, I want the row in my Report Component that contains datafield OFCvRAVAR<>0 to be highlighted red.

    Select the row to be formatted through the Report Explorer. Select Formatting Rules ellipses

     

    Move the Formatting Rule from Rules Available to Rules Applied

    Done.

    • Oscar's avatar
      Oscar
      Contributor
      3 years ago

      Yes I can ... I think I stumbled upon the solution ... I will document below in case anyone needs help with conditional formatting. 

      Create a Formatting Rule and assign a condition (and required formatting). In my case, I want the row in my Report Component that contains datafield OFCvRAVAR<>0 to be highlighted red.

      Select the row to be formatted through the Report Explorer. Select Formatting Rules ellipses

       

      Move the Formatting Rule from Rules Available to Rules Applied

      Done.