Is there a way to be able to sum a column when there is a dollar sign in front of it?
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.
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.
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?
Hello bdisk,
Could you please review the sample attached to this post and see if it meets your requirements.
Please feel free to let me know if I misunderstood you or if you have any other questions.