Risks, limitations and known issues

These risks and limitations must be understood by report designers. No warnings or error messages are produced on incorrect use.

If you do not refresh the whole report, only changed values are transferred from the server to the web browser. This can improve performance, and avoid unwanted visual effects which can occur in some browsers. But there is a risk that the report displayed in Application Studio WebServices will differ from the report on the server.

To avoid this, use the Single Cell and None options only if the visible area of the report does not change when the action is executed.

If only some values change in the report, use the Range option. For example, if the values of only cells M10, M11, N10 and N11 change when an action is executed, specify a range of M10:N11.
Note: If not all the affected cells are included in the range, problems will occur.

For example:

  • A set parameter action changes cells D1:D2 and X1:X2.
  • The report designer specifies the refresh range D1:D2.
  • When the action is executed in Application Studio WebServices only cells D1 and D2 are updated. The true state of the report will not be displayed until the whole report is refreshed, either by execution of another action or by reloading the report in the browser.
    Note: If you click the browser's Refresh button, you are logged off from Application Studio WebServices

Limitations

Several visual properties of cells can be changed by the execution of an action. But not all these properties can be refreshed by the Refresh input.

This presents a risk if unsupported cell properties are used, for example, to highlight important data in a report.

Only these cell properties can be updated:

  • Text
  • Text color
  • Text bold
  • Text italic
  • Text strikethrough
  • Underline
  • Background
  • Graphic

The Refresh option is supported only on these cells:

  • Cells which contain only text
  • Cells which contain only graphics
  • Cells which contain actions

These cells cannot be refreshed with the Refresh option:

  • Cells which contain list objects
  • Cells which contain charts

Known issues

These examples describe known issues:

  • You have a short text that fits within a cell. You use an action to replace that text with a longer text. You refresh only the cell containing the short text. In Application Studio the text overflows into the adjacent cells. But, in Application Studio WebServices the width of the cell expands to accommodate the text and the contents of adjacent cells are moved to the right.
  • A cell contains value N, provided by a variable. An action changes the value of the variable to N+1. The refresh input option is None.

    When the action is executed in Application Studio WebServices the displayed value is N. But if you export the report, the displayed value is N+1.

  • Cell B2 contains an empty string, provided by a variable. Cell C2 contains the formula =B2. An action changes the value of the variable to "TEXT". The refresh input option is Single Cell.

    When the action is executed in Application Studio WebServices only cell B2 displays TEXT. This is correct. But, if you export the report, cells B2 and C2 both display TEXT. So, exporting a report overrides the Single Cell refresh input and recalculates the whole report.

  • Cell B2 contains the formula =A1. Cell A1 contains a Select Element action. The refresh input option is Single Cell. The action is executed and an element is selected. Correctly, the selected element is displayed only in cell A1. The action is executed a second time, but no element is selected and Cancel is clicked.

    Cell B2 displays the element in A1. So, clicking Cancel in the Select Element dialog overrides the Single Cell refresh input and recalculates the whole report.

  • Cell B2 contains a report variable with a value of 10. B2 contains a Select Element action. The action also changes the value of the report variable to 99. But the refresh input is None.

    When the action is executed in Application Studio WebServices the Select Element dialog is displayed. When OK is pressed, cell B2 displays 99. The whole report has been refreshed.