Number fromatting Question in Summary Levels

(6 posts) (2 voices)
  1. ajdjackson, Member


    I have set a the following style on a column:

    select 'dbr.colstyle','perqty','perval','%0.1N %;-;[color:red;](%0.1N) %;';

    This works as expected except on any of the summary levels where the colour is black instead of red. All the other elements such as the parenthesis display - just the colour doesn't change when negative.

    Any thoughts on why this isn't working. Thanks.


  2. myDBR Team, Key Master

    Can you show (a simple version) of your report code which show this?

    myDBR Team

  3. ajdjackson, Member

    Thanks for the speedy reply.


    select 'dbr.calc','[perqty]','(([tqty]-[lqty])/[lqty])*100';
    select 'dbr.calc','[perval]','(([tval]-[lval])/[lval])*100';
    select 'dbr.hdr','qtr';
    select 'dbr.hdr','cust';
    select 'dbr.sum','tqty','lqty','lval','tval';
    select 'dbr.css','.summary.cell.align_l.summary_level.summary_level2 {visibility:hidden;}';
    select 'dbr.css','tr.summary_row.rowhdr_change > td {font-weight:bold;background-color:#f2f2f2;}';
    select 'dbr.css','tr.summary_row.row > td {font-weight:bold;}';
    select 'dbr.css','tr.summary_row.row.sortbottomhdr_change > td {background-color:#e6e6e6;font-weight:bold;}';
    select 'dbr.colstyle','tval','lval','%0.0f';
    select 'dbr.colstyle','perqty','perval','%0.1N %;-;[color:red;](%0.1N) %;';
    select 'dbr.colstyle','qtr','[text-align:center;color:blue;font-weight:bold;]';
    select 'dbr.summary.text','prod','Totals '; select qtr as "Quarter[qtr]",
    cust as "Customer[cust]",
    prod as "Product[prod]",
    tyqty as "This Year Qty[tqty]",
    lyqty as "Last Year Qty[lqty]",
    null as "Variance %[perqty]",
    tyval as "This Year Value[tval]",
    lyval as "Last Year Value[lval]",
    null as "Variance %[perval]"
    from sales_tmp
    order by 1,2,3;

  4. myDBR Team, Key Master

    we can replicate it. We'll take a close look at it.

    myDBR Team

  5. myDBR Team, Key Master

    You can try the newest build. The color should show now.

    myDBR Team

  6. ajdjackson, Member

    Brill - works great!




You must log in to post.