4 Replies Latest reply: Jan 9, 2012 2:45 AM by Ashok Kumar Jayabal RSS

    Change the Total Mode default settng by SetProperties

    yaizawa

      set expr2 = cp.Expressions.Item(1).Item(0).Data.ExpressionVisual
      expr2.Label.v = "UOM"
      expr2.(**** need help for Total Mode default setting change *****)= 'No Totals'
      set dims = cp.Dimensions
      dims(0).Title.v = "CUSTOMER"
      dims(1).Title.v = "LOCATION"
      dims(2).Title.v = "ITEMNUMBER"

      obj.SetProperties cp

      I am trying to change the Total Mode setting in Straight Chart Properits to 'No Totals' instead of 'Expression Total' as default by macro. Could someone fill the third line mentioned above?