http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/26406.aspxFri, 20 Mar 2015 20:59:01 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:26406Method_Justin0http://forums.method.me/cs/forums/thread/26406.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=26406<p><span id="mce_0_start" style="overflow:hidden;">Hi Alex,</span></p> <p><span id="mce_0_start" style="overflow:hidden;"></span>Although the subtotal row will total whatever is contained in your SQL override, you cannot change its formatting.&nbsp;<span id="mce_1_start" style="overflow:hidden;"><span id="mce_2_start" style="overflow:hidden;">This goes for both alignment as well as<span id="mce_3_start" style="overflow:hidden;"> number of</span> decimal places.</span></span></p> <p>- Justin</p>http://forums.method.me/cs/forums/thread/26403.aspxFri, 20 Mar 2015 20:07:56 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:26403alexhuang0http://forums.method.me/cs/forums/thread/26403.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=26403<p>Hi,</p> <p>In a Grid, I use SQL override<span id="mce_0_start" style="overflow:hidden;"> for a column, and I enable &quot;subtotals&quot; for this column. However, this &quot;subtotals&quot; 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.</span></p> <p>And, for this same column, I set &quot;<span>Cell Alignment Override:&quot; as Center, but the value is always left-aligned, is there any way to make it center-aligned?</span></p> <p><span><br /></span></p> <p><span>Thanks.</span></p>