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 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.

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.