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
765
Summate column
posted

Hello everyone, I hope you can help me.
How can (vb.net) in the grid a column "Brutto" sum and the result in a num field output

numBruttoGesamt.Value =

Hope you can help me.

best regards
Ronald

  • 1980
    Offline posted
    Hello Ronald,

    To implement formulas on your form, drag the UltraCalcManager component from the Toolbox onto it. I have attached a sample windows forms project which has been set up with UltraGrid and UltraCalcManager. The data table is a set of products, each product having unit price and quantity. The values in the ‘Total’ column are calculated by multiplying the product’s unit price by its quantity. I have done this in code by setting the ‘Total’ column’s property Formula.

    To sum up all the values in the ‘Total’ column you should create a calculated summary. This is achieved by adding a new summary to the band Summaries collection. In my sample project this is done in code. However, the same can be achieved using the grid designer, under the node: "Band and Column Settings > Band[0]". You will find the Summaries collection in the properties grid on the right.

    Let me know if you need any further assistance regarding this matter.
    UltraGridSample.zip