2.2.7 Setting Global Worksheet Options

To set global Worksheet options using Visual Composer, click the 'Options' button in the toolbar. In Style Studio, select the 'Worksheet Properties' option from the File menu.

There are several global options available:
• 'As data source to reports' specifies that the Worksheet is accessible for data binding in reports, as well as for use by Viewsheets.
• 'Alias' specifies a designation to be used in place of the actual Worksheet name. The alias replaces the Worksheet name in all contexts except the Objects tab and the 'Export Assets' page in Enterprise Manager. These always display the actual Worksheet name.
• 'Description' specifies a description for the Worksheet to appear in the Style Studio 'Open' dialog box and the Portal's Ad Hoc Wizard.
• 'Auto Save' automatically saves the current Data Worksheet at the period specified by the 'Interval (minutes)' setting.
• 'Design mode sample data size' globally limits the number of rows returned by any query or subquery for Live Preview mode, and for Viewsheet design view.
If a table in the Worksheet is composed from multiple sub-queries, each individual subquery result will be capped at the specified 'Design mode sample data size' maximum. This may prove efficient when the final table is itself row-limited. For example, if the final table displays only 20 rows in Live Preview mode, it may be unnecessary for the component sub-queries to each retrieve thousands of rows, and restricting these query result sets may be desirable. However, artificially limiting queries in this way can also yield an unrepresentative Live Preview result in some cases.
See Also
Using a Data Table in a Report, for details on report data binding.
Limiting the Number of Rows in a Table, for a survey of methods.
Viewing the SQL Query Plan of a Table, to inspect composition of the table query.
| << 2.2.6 Navigating a Data Worksheet | © 1996-2013 InetSoft Technology Corporation (v11.5) | 3 Assets: Reusable Worksheet Components >> |