Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Amornrat
150
Is there a way to format string in the summary row?
posted

By default the Sum or Average displays ex. Sum = 23456788.

I would like to format it as Sum = 23,456,788

Also in a Date field, it displays ex. Max = 2/3/2010 12:00:00:00 AM.

Can i set it to show only date (no time)?

Thank you.

 

Parents
No Data
Reply
  • 6912
    Suggested Answer
    posted

    Hi,
    This snippet sets a format string for the Sum operand on a TextColumn containing double data:
    <ig:TextColumn Key="DoubleData">
     <ig:TextColumn.SummaryColumnSettings>
      <ig:SummaryColumnSettings>
       <ig:SummaryColumnSettings.SummaryOperands>
        <ig:SumSummaryOperand FormatString="{}{0:#.#%}" />
       </ig:SummaryColumnSettings.SummaryOperands>
      </ig:SummaryColumnSettings>
     </ig:TextColumn.SummaryColumnSettings>
    </ig:TextColumn>

    You can use a similar syntax to fromat the date of the max operand on a DateColumn.

    Hope this helps.

Children