If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Alternate Row Highlighting

Started by naveen.odi@gmail.com, 26 Jul 2015 12:35:17 AM

Previous topic - Next topic

naveen.odi@gmail.com

Hi, i want to highlight first 3 rows in 'Yellow' colour & next 3 rows in "Green" colour & next three rows in "red" colour......Can anyone guide me?

NIEK87

Select the column(s) that you want to highlight:

  • Click Conditional Styles
  • Create an advanced conditional style
  • Use "RowNumber () < 4" to target the first three rows
  • Create the Style
  • Repeat for "RowNumber () < 7" and "RowNumber () < 10"

naveen.odi@gmail.com

Thanks for your Help. My report contains 1000 rows.......

NIEK87

Do you  mean that you want the following?


  • Rows 1 to 3: yellow
  • Rows 4 to 6: green
  • Rows 7 to 9: red
  • Rows 10 to 12: yellow
  • etc.

You can achieve that by creating a second object with the expression: mod(running-count([Your Object]);9)
Change the advanced conditional style to:
[second object] between 1 and 3: yellow color
[second object] between 4 and 6: green color
other values: red color

naveen.odi@gmail.com

Yes this is the one I need for my requirement. Thanks for your valuable help....