2.4.9  Limiting Data Retrieved by a Viewsheet

It is common for administrators to limit data retrieved by user queries, in order to avoid overtaxing database resources. Administrators can limit the number of records retrieved in design mode, preview mode, and at runtime (in the Portal). The design mode limit can also be set in the Worksheet. See the related links for more information.

In cases where a Worksheet Data Block is slow or returns an empty result set, you can apply formatting features (e.g., highlights) by Suppressing Query Execution in Design View.

See Also

Web Properties and Safeguards, in Administration Reference

Limiting Query Size and Execution Time, in Administration Reference, for global safeguards.

Setting Global Worksheet Options, in Data Mashup, to limit Viewsheet data in design view.

Limiting the Number of Rows in a Table, in Data Mashup, for other Worksheet-level safeguards.

<< 2.4.8 Changing Viewsheet Scope © 1996-2013 InetSoft Technology Corporation (v11.5) 2.4.10 Suppressing Query Execution in Design View >>