Saving a New Worksheet
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. See Controlling Access to an Asset for further details.
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.
Create a new Data Worksheet that includes a Composition Table listing all of the orders from the states of NY and NJ, and save the Worksheet in the Asset Repository.
Follow these steps:

1. Create a new Worksheet.
2. In the Asset Repository, expand the 'Data Source' node, 'Orders' node, and 'DWS' node.
3. Drag the 'NJ Orders' query onto an empty cell on the Worksheet. This creates a new table, 'NJ Orders1'.
4. Drag the 'NY Orders' query onto an empty cell on the Worksheet. This creates a new table, 'NY Orders1'.
5. Select both tables by holding down the Ctrl key and clicking on the title rows of both tables.

6. Click on the 'Concatenate Table' button on the toolbar, and select 'Union'. This creates a new table, 'Query1', which is the union of the data from the 'NJ Orders1' and 'NY Orders1' tables.
7. Set the 'Query1' table as the Primary Table by right-clicking on its title row and selecting 'Set as Primary'.


8. Click on the 'Save' button in the toolbar to save this Data Worksheet. This opens the 'Save Worksheet' dialog box.
9. Enter “Orders” for the Worksheet name, and select 'Global Worksheet' as the scope.

10. Click on the 'OK' button.
Note that the 'Orders' asset is saved under the 'Global Worksheet' node on the asset tree.

See Also
Controlling Access to an Asset, for information about scope rules.
Using an Asset, for information about binding worksheet results to elements.
Showing Live Data in a Table, for information on setting maximum display rows.
Repository Directory, in Administration Reference, for information on the SREE Home directory.
| << Saving a New Version of an Existing Worksheet | © 1996-2013 InetSoft Technology Corporation (v11.4) | Visibility of Saved Worksheet Assets >> |