1. 

   spyhunter88, Member

   Hi, I have a column with cellvlass define like:
   

   select 'dbr.hdr', 'Brand';
   select 'dbr.cellclass', 'Diff', '[Dcolor]';
   
   select 'dbr.footerstyle', 'background-color: #F7F2E0;font-weight: normal;color:#0101DF;';
   
   select Brand, Model, Value - Budget as Diff, IF(Value>=Budget,'text_green','text_red') as '[Dcolor]' from Mobile.Mobile_Sales
   order by Brand, Model;

   This works for normal row, but my client request to apply Dcolor in the footer rows. But how to calculate the value of 'Dcolor' in footer row while 'dbr.calc' only work for number?
   And will the 'dbr.cellclass', 'dbr.cellstyle' work with summary?

   Thanks,
2. 

   myDBR Team, Key Master

   Hi,
   dbr.cellclass and dbr.cellstyle are not applied to summary columns. You can use dbr.footer.colclass instead, but you have to calculate the class yourself.

   dbr.calc does work with strings, you just need to set the colstyle for that column to be a string ('%s').

   We can see if we could add dbr.footer.cellclass -command that would apply the class for the footer column based on the data.

   --
   myDBR Team
3. 

   myDBR Team, Key Master

   Hi,
   the latest build includes the dbr.footer.cellclass and dbr.footer.cellstyle commands which allows summary column styling based on data. Also, dbr.calc works now better with non-number fields.

   --
   myDBR Team
4. 

   spyhunter88, Member

   Many thanks for that update.

Reply

You must log in to post.