Pages

Monday, August 6, 2012

#RECURSIVE Error in WebIntelligence

#RECURSIVE occurs when Web Intelligence cannot make a calculation dueto a circular dependency.

Example:Using the NumberOfPages() function

If you place the NumberOfPages() function in a cell whose Autofit Height or  Autofit Width properties are set, Web Intelligence returns #RECURSIVE because the placing of this formula in an autofit cell creates a circular dependency. Web Intelligence must know the exact size of the report before itcan return a value from the function, but the size of the cell (which affects thesize of the report) is determined by the cell content

AutoFit retains the current cell size as the minimum size and enlarges the cell size if the cell content is larger than the minimum size specified. Some Web Intelligence functions are incompatible with AutoFit cells. If any of these functions are placed in an AutoFit cell, Web Intelligence returns the #RECURSIVE error message as the function output.
For document performance, documents with AutoFit properties applied in tables will take longer to display in the Java Report Panel or InfoView. For large documents, it is recommended that a fixed sized cell width and cell height be specified instead.

No comments:

Post a Comment

How Many's!!!

  • ()