This section discusses Worksheet storage and scope. To save a new version of an existing Worksheet, click the 'Save' button in the toolbar, or press Ctrl-S on the keyboard. This replaces the older version with the current version, retaining the same name.
To save the new version of the Worksheet under a different name, click the 'Save As' button. This opens the 'Save Worksheet' dialog box. Then follow the instructions for saving a new Worksheet below.
To save a new Worksheet, follow these steps:
1. Click the 'Save' button in the toolbar, or press Ctrl-S on the keyboard. This opens the 'Save Worksheet' dialog box.
2. Under the Repository tab, enter a name for the Worksheet in the 'Name' field.
3. Select the appropriate scope for the saved Worksheet ('Global Worksheet', 'User Worksheet', or a sub-folder). The scope in which you save the Worksheet determines the accessibility of the Worksheet to different users.
4. Under the Options tab, select 'As data source to reports' to make the Worksheet result (i.e., the Primary asset) available to reports as well as Viewsheets. This will allow you to bind the Worksheet result to report elements such as tables, charts, and sections.
5. Set the 'Design mode sample data size' to the maximum number of rows that wish tables in the Worksheet to retrieve.
6. Click 'OK' to save the Worksheet.
The Worksheet is saved to the Asset Repository, and appears in the Asset Repository tree under the specified scope. Saved Worksheets are stored in a file called asset.dat in the SREE Home directory.