cellstyle/cellclass in summary row?

(4 posts) (2 voices)


No tags yet.

  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?


  2. myDBR Team, Key Master

    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

    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.


You must log in to post.