Posted 4/26/2007 11:57:09 AM | | | | 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 PM | | | | 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
|
| |
|