7.4.2  Highlighting Data in a Table

To highlight data in a Table, follow these steps:

1. Open the Style Studio Properties panel. (Select 'Properties Pane' from the Style Studio 'Window' menu.)

2. Select the data cell or row of the Table to which you want to apply the highlight. (See Selecting a Cell, Row, or Column of a Table for more information.)

3. Click the Highlight tab in the Properties panel.

 

4. Specify the highlight formatting and condition. This is the same procedure as for a Text element highlight. See Highlighting a Text or Textbox Element for details.

Walkthrough

In this example, you will highlight the cells in the 'Total' column with a a red background when they contain a value under $5000, and highlight the entire row with a green background when the total is above $20,000. Follow the steps below:

1. Click the 'New' button in the Style Studio toolbar. This opens the 'New Asset' dialog box.

2. In the left panel, select the 'Report' node. In the right 'Types' panel, select 'Blank Tabular Report' and click 'OK'.

3. Expand the Style Studio Toolbox panel.

4. Click the 'Table' button in the Toolbox panel to open the 'Data Binding' dialog box for a new table.

5. Under the Data tab, bind the table to the 'All Sales' query from the 'Orders' data source, and click 'Finish'.

Add the red highlights for low totals (under $5000):

6. Open the Style Studio Properties panel. (Select 'Properties' from the 'Window' menu.)

7. Select the body cell under the 'Total' header of the Table.

8. Select the Highlight tab in the Properties panel.

9. Click 'New' to add a new highlight, and name it “Poor Performance”.

10. Select a red color for the 'Background' in the 'Properties' pane.

11. Click the 'Edit Condition' button, and append the following condition:

[Total] [is] [less than] [5000]

12. Click 'OK' to close the dialog box.

 

Next, add the green row-based highlights for high totals (over $20,000):

13. Select the body row of the table by clicking next to it in the left margin. You will see an arrow indicating that the row is now selected.

 

14. Select the Highlight tab in the Properties panel.

15. Click 'New' to add a new highlight, and name it 'Good Performance'.

16. Select a green color for the 'Background' in the 'Properties' panel.

17. Click the 'Edit Condition' button, and append the following condition:

[Total] [is] [greater than] [20000]

18. Preview the table and observe the cell and row highlighting.

 

The existence of a row-based highlight is indicated by an asterisk in the left margin next to the row, as shown below. To edit a row-based highlight, click the asterisk to select the row, and then proceed as shown above.

 

<< 7.4.1 Highlighting a Text or Textbox Element © 1996-2013 InetSoft Technology Corporation (v11.5) 7.5 Formatting >>