1 Reply Latest reply: Apr 26, 2010 6:40 AM by Shivarama krishna K RSS

    Disable expression by a macro

      Can a expression be disable with a macro???

        • Disable expression by a macro
          Shivarama krishna K

          Hi,

          Yes expression can be disabled through macro.

          I found this example in the API Guide.Qvw file.

          Just go through the sample

          //////////////////////////////////////////////////////// Below is the Sample Code which will create a straight table and disable's the first expression//////////////////////////

          Set chart=Activedocument.activesheet.createStraightTable

          Chart.AddDimension "Customer'

          Chart.AddDimension "ProductType"

          Chart.AddExpression "Sum(Amount)"

          Chart.AddExpression "Count(Customer)'

          Set Cp=Chart.GetProperties

          Set Expr=Cp.Expressions.item(0).Item(0).Data.ExpressionData

          Expr.Enable=False

          Chart.Set Properties Cp

          //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////