0 Replies Latest reply: Sep 2, 2013 9:18 AM by SVenkatesh RSS

    Interactive reporting CreateLimit function

    SVenkatesh

      Im using Interactive reproting 11.1.2.3.

      In the dashboard section for updating the values for the dropdown list boxes, im reading values from result section and add. Out of 10 dropdown boxes only one was not working.
      The code i used was

      function createlim(limitfieldname)
      {
      var selectedObject = ActiveSection.Shapes[objectName];//defining dropdown box
      var resultsSection =ActiveDocument.Sections[resultsSectionName];//defining resultset
      selectedObject.RemoveAll();
      var newLimit = resultsSection.Limits.CreateLimit(limitFieldName);
      newLimit.RefreshAvailableValues();
      ...
      }

      While creating it throws error Limit cannt be created. The column used from the result section is a computed item contains NVL function.  but for other fields it is working.

      Please suggest what is wrong.

       

      Thanks

      Venkat