Number fromatting Question in Summary Levels

(6 posts) (2 voices)
  • Started 2 weeks ago by ajdjackson
  • Latest reply from ajdjackson
  1. ajdjackson, Member

    Hi

    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.

    Jake

    Posted 2 weeks ago #
  2. myDBR Team, Key Master

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

    --
    myDBR Team

    Posted 2 weeks ago #
  3. ajdjackson, Member

    Thanks for the speedy reply.

    Jake

    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;

    Posted 2 weeks ago #
  4. myDBR Team, Key Master

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

    --
    myDBR Team

    Posted 2 weeks ago #
  5. myDBR Team, Key Master

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

    --
    myDBR Team

    Posted 2 weeks ago #
  6. ajdjackson, Member

    Brill - works great!

    Thanks

    Jake

    Posted 2 weeks ago #

Reply

You must log in to post.