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
445
newbie question
posted

I would like to use cal manager to sum columns 5 thru 10 on band 0, row 0 and place the SUM in a ultracurrency editor. I have tried many iterations but always get Invalid or unavailable reference. The grid is loaded from a business object at runtime and not from the designer. I have set up the editor per one of the example apps for only 1 column for testing and still does not work. Any pointers would be most appreciated.

 Dim calcSettings As CalcSettings = Nothing

        calcSettings = Me.ultraCalcManager1.GetCalcSettings(Me.pvNet)
        calcSettings.Alias = "NetAmount"
        calcSettings.PropertyName = "Value"
        calcSettings.Formula = "sum([Me.grdSummary.DisplayLayout.Bands(0)/Column 5])"