Hi Borris,

I'm having difficulty opening the attached project (it tells me something about newer version.)

Would you be able to post the code here?

Thanks.

I was able to open it. 

            e.Layout.Bands[0].Columns[0].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Currency;

            e.Layout.Override.SummaryDisplayArea = Infragistics.Win.UltraWinGrid.SummaryDisplayAreas.TopFixed;

            e.Layout.Override.AllowRowSummaries = Infragistics.Win.UltraWinGrid.AllowRowSummaries.True;

            e.Layout.Bands[0].Columns[0].Format = "$##,###";

However, since my grid data and columns are dynamic, I can't know which column to set these properties on. I would have to add the $ sign in SQL.

Any ideas?

Thanks.

Hello,

Could you please attach a small sample project with your scenario and explain your requirements in this connection. From your posts what I understood is that you have a money column in SQL and you want to use the summaries for that column in our 'WinGrid'. If that is not correct please do not hesitate to let me know, I will be happy to assist you further.

Yes, that correct - except its not a money field since theres a dollar sign in front of it, so it's a varchar field now. 

Is there a way to sum varchar fields?

(As I've mentioned, the grid columns are dynamic, and therefore I can't just format and add the dollar sign in code or in a designer property.)

Hello again,

Did this approach work for you? If not, please do not hesitate to ask anything related to this topic.

I still didn't resolve this. I will try to see if I can determine if the column type is money by using the DataType property on each column and format accordingly.

Thanks.

Hello,

I am just checking about the progress of this issue. Please let me know If you need my further assistance on this.

Hello bdisk,

I do not see how the grid will sum the varchar field. You would have to make a custom summary by casting the values to double or something like that.

Please do not hesitate to contact us if you need any additional assistance.