Crosstab cell background color change according to database field.


  • I have a crosstab report .  I would like the "summerized field" cell to be formatted to display a certain color.color's RGB values are coming from stored procedure's three columns red,green,blue.

    I have tried to set the Background of this cell to use the following code:

    WhilePrintingRecords ;
    Color ({myField.Red}, {myField.Green}, {myField.Blue})

    However, this changes all of the cells in each row to the color of the first row/cell.

    first row/cell is the correct color, but the remaining cells are all set to the same color.

    thanks in advance for your help!

    Thanks & Regards, Pulin
    Tuesday, January 18, 2011 7:03 AM

All replies

  • It's a limitation of the CrossTab Wizard. Work around is to create a manual report that emulates a crosstab format.

    Thank you


    Don Williams
    Monday, March 21, 2011 2:49 PM