Method Community


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


    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?


    Chief Architect
    Yi Systems, Inc.
  • 03-20-2015 3:59 PM In reply to

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


    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
Page 1 of 1 (2 items)