# Reporting Simple Table Cell Fill Dynamic Control **URL:** \ **Category:** Ignition\ **Created:** [March 10, 2017, 10:47pm UTC](https://forum.inductiveautomation.com/t/reporting-simple-table-cell-fill-dynamic-control/12775 "2017-03-10T22:47:05Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![0sm0](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/0sm0/32/15228_2.png) [@0sm0](https://forum.inductiveautomation.com/u/0sm0)\ **Post date:** [March 10, 2017, 10:47pm UTC](https://forum.inductiveautomation.com/t/reporting-simple-table-cell-fill-dynamic-control/12775/1 "2017-03-10T22:47:05Z")
Hi Guys, In the old Reporting Module i used to use the Property Expressions on a Simple Table Cell to alter its Fill colour based on specific criteria. With the new Reporting system I cant see how to simply replicate the same control without using a parameter as a dynamic data key for each individual cell I want to change (they all have different criteria)? I can easily use key chain expressions to alter the text of cells but cant see how to use this functionality for the Fill property? Any help or ideas appreciated ![:scratch:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/76d1620bec252bfac07050c889ff5a91dc8a9c25.gif ":scratch:") cheers ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [March 13, 2017, 8:49pm UTC](https://forum.inductiveautomation.com/t/reporting-simple-table-cell-fill-dynamic-control/12775/2 "2017-03-13T20:49:03Z")
In the 7.8+ reporting module you would use [table row versioning](https://docs.inductiveautomation.com/display/DOC79/Table+Row+Versioning) to accomplish this - basically, each different row style has a ‘version’ key, using keychain expressions - and whichever one evaluates first defines that row’s style. I’ve attached a sample report that I created that has three different row versions based on the values of different columns. [inductiveuniversity.com/video/t … ioning/7.9](https://inductiveuniversity.com/video/table-row-versioning/7.9) [Table Row Versioning - Reporting.proj](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/0264918f4bcb96f56038f1a6bb7d8c4afafd8014.proj) (20.5 KB) ---
**Author:** ![0sm0](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/0sm0/32/15228_2.png) [@0sm0](https://forum.inductiveautomation.com/u/0sm0)\ **Post date:** [March 13, 2017, 11:56pm UTC](https://forum.inductiveautomation.com/t/reporting-simple-table-cell-fill-dynamic-control/12775/3 "2017-03-13T23:56:36Z")
Thanks for the Reply I was after Individual Cell Formatting on a ‘Simple Table’, not Versioning of Rows in a ‘Table’. How I used to do it. ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/13e4c878d99a23d93f41fff55899bbcb8098cdb9.png) Cheers ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [March 14, 2017, 5:20pm UTC](https://forum.inductiveautomation.com/t/reporting-simple-table-cell-fill-dynamic-control/12775/4 "2017-03-14T17:20:09Z")
EDIT: It's actually definitely possible to do this, as Jae pointed out. Your keychain expression will still work in the newer reporting engine if you set it to be a dynamic data key. This is definitely not made very clear, but your exact expression should work in a new table once you've set the property to be dynamic. > [@](#): > > Understood - apologies for the confusion. It does appear that there's no clean mapping of the older functionality on the simple table in the new reporting module. You would need an additional datasource/parameter for each value. You could use a scripting datasource to create the necessary data keys in a programmatic way instead of doing it all manually, at least. ---
**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\ **Post date:** [March 14, 2017, 6:12pm UTC](https://forum.inductiveautomation.com/t/reporting-simple-table-cell-fill-dynamic-control/12775/5 "2017-03-14T18:12:12Z")
You can still do this. Right click on the Fill Color property and select “Use dynamic data key” ---
**Author:** ![0sm0](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/0sm0/32/15228_2.png) [@0sm0](https://forum.inductiveautomation.com/u/0sm0)\ **Post date:** [March 14, 2017, 10:53pm UTC](https://forum.inductiveautomation.com/t/reporting-simple-table-cell-fill-dynamic-control/12775/6 "2017-03-14T22:53:09Z")
Haha 😊 I feel stupid… I was using the @ before and after as with other Key Expressions as i was referencing a key. Thanks for the help. ![:thumb_left:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e26afb081ddde6df016df6ee49159cf56aaca688.gif ":thumb\_left:") ---
**Author:** ![Dilan](https://avatars.discourse-cdn.com/v4/letter/d/ba8739/32.png) [@Dilan](https://forum.inductiveautomation.com/u/Dilan)\ **Post date:** [May 9, 2017, 11:33am UTC](https://forum.inductiveautomation.com/t/reporting-simple-table-cell-fill-dynamic-control/12775/7 "2017-05-09T11:33:11Z")
Hello, I just wanted to say thank you, I found this discussion very useful. I wanted to change the color of a cell dependent on a value and this helped me get there. I created a test parameter called “testph” and then used this as my dynamic key for the fill colour property of the textshape: testph\>=13?“FF0000A3”:(testph\>=11.6?“FFFF00”:(testph\>=9.6?“3BDB3B”:(testph\>8.6?“FFFF00”:“FF0000A3”)))