Highlight: red < 100; yellow < 3000; green >= 3000
Demonstrates how to print other objects inside the matrix. In this example each data cell has an indicator which is red if value < 100; yellow if value < 3000; or green if value >= 3000. To do this:

- create a matrix;

- put three Shape objects inside the data cell;

- increase the cell's width to contain both text and indicator. To do this, select the cell, go to Properties window and set the Padding.Left property to 50;

- in the same window, click "Events" button and create a "BeforePrint" event handler;

- in the handler, set the shapes' visibility and color based on the cell's Value. See the handler code for more details.

REVENUE BY EMPLOYEE
 
 
Employee
2011
2012
2013
2014
2015
Total
Andrew Fuller
$3,900.00
$2,100.00
$1,800.00
$7,800.00
Janet Leverling
$6,100.00
$3,200.00
$9,300.00
Nancy Davolio
$3,300.00
$2,700.00
$3,100.00
$1,700.00
$10,800.00
Steven Buchanan
$3,999.00
$8,100.00
$12,099.00
Total
$13,300.00
$8,000.00
$7,099.00
$8,100.00
$3,500.00
$39,999.00
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Generated by FastReport .NET