Method Community

Method:CRM

 

Method Community » Method:Classic » Method:Classic General Q&A » Display format of "Subtotals" of a Grid column

Display format of "Subtotals" of a Grid column

Last post 03-20-2015 3:59 PM by Method_Justin. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 03-20-2015 3:07 PM

    Display format of "Subtotals" of a Grid column

    Reply Contact

    Hi,

    In a Grid, I use SQL override for a column, and I enable "subtotals" for this column. However, this "subtotals" is display with decimal point. Even I tried to use CAST(my_column AS Int), it is still the same. Is there any way that I can change the display format for this auto-calculated value? Thanks.

    And, for this same column, I set "Cell Alignment Override:" as Center, but the value is always left-aligned, is there any way to make it center-aligned?


    Thanks.

    Chief Architect
    Yi Systems, Inc.
    alexhuang@yisystems.com
    www.yisystems.com blogs.yisystems.com
    Software.Web.Cloud.IT

  • 03-20-2015 3:59 PM In reply to

    Re: Display format of "Subtotals" of a Grid column

    Answer
    Reply Contact

    Hi Alex,

    Although the subtotal row will total whatever is contained in your SQL override, you cannot change its formatting. This goes for both alignment as well as number of decimal places.

    - Justin

    Justin Henderiks
    Technical Sales Specialist
    Method Integration Inc.
    Toll Free: 1.888.925.6238
    Local and overseas: 416.847.0400
    Fax: 416.640.6027
    E-mail: j.henderiks@method.me
Page 1 of 1 (2 items)