FORUMS

c360 Forums
 Home        Members    Calendar    Who's On

Welcome Guest ( Login | Register )
      



How do I add alternating colors to my rows in...Expand / Collapse
Message
Posted 4/26/2007 11:57:09 AMPost #1411
 

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie
Adding color highlights to a report can help to point out areas of interest, such as an expense amount that has exceeded budget, or simply assist the reader of the report in staying focused on the numbers in complex and visually crowded reports. In the "old days" we had greenbar paper - alternating color bands designed to help analyze those reams of numbers created by countless 9-pin dot matrix printers. Today, we can add just a little embelishment to our reports in the form of an expression, and derive a similar effect. This really helps to step your reports up to "board-quality" presentation and truly assists the reader of the report in better understanding the numbers.

To add conditional formatting to your detail rows in a table, move the mouse to the leftmost position on the table detail row. Your cursor should change to a right-pointing arrow with a dot on the left side of it. Click the mouse to select your entire row. Alernatively, you could use a Shift-click mouse action to select adjacent cells in a row or Ctrl-click mouse action to select individual cells.

Once your cells have been selected, click the Format tab beneath the Table Text Box Tools group on the Ribbon. From there, click the arrow to the immediate right of the Shape Fill button and select "Expression" from the dropdown menu. With the Expression Editor open, add the following expression:

=IIf(RowNumber(Nothing) Mod 2,"White","#D6E0EC")

The expression counts the current row number and evaluates whether it is even or odd, by determining if it can be divided evenly by the number 2. If even, the color is white, otherwise whatever color you desire. The expression allows for color constant names that are consistent with the CSS specification or equivalent hexadecimal values. Examples of both are shown above.




Craig Todd
Director of PreSales
90 Degree Software
Posted 4/30/2007 2:36:50 PMPost #1413
 

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie
Correction!

The previous post says to click the Format tab for the Table Tools group. My apologies - this was a typo. Click the Format tab for the TEXT BOX TOOLS group, then proceed as indicated.

Sorry for the confusion.
Craig


Craig Todd
Director of PreSales
90 Degree Software

« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: kanika.jackson, Ken Champion

PermissionsExpand / Collapse

All times are GMT -5:00, Time now is 7:44am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 1.234. 16 queries. Compression Enabled.