2.1 Quick Start: Creating a Viewsheet
This section walks you through the creation of a simple Viewsheet. The exercise uses an existing Worksheet called 'ProductSales', which is included in the default installation. Please contact your administrator if the Worksheet is not available.
Walkthrough
The sample 'ProductSales' Worksheet returns customer and order information. It is based on the sample 'Orders' data source. In this section, you will create a Viewsheet that incorporates output and selection components to provide quick analysis of the ProductSales' data.

To create this Viewsheet, follow the steps below:
It is typical to link a Viewsheet to a Worksheet, query, model, or table at creation time, although you can also do this later.
1. Launch the Visual Composer from the Portal. (Select the Design tab and then the 'Visual Composer' option.)

2. Click on the 'New Viewsheet' button. The 'New Viewsheet' dialog box will open. Expand 'Global Worksheet' and the 'Tutorial' folder. Select the 'ProductSales' Worksheet. Click 'OK'.

3. Drag the 'SalesByDate' Data Block from the left pane into the grid. This creates a Table containing the Data Block's columns.

4. Expand the 'SalesByDate' node to show the list of fields within that Data Block.

5. Click and drag the 'State' field to an empty cell in the grid. This creates a Selection List that will let you choose the states to include.

6. To limit the dates included in the data set, drag a 'Range Slider' component from the left pane into an empty cell in the grid.

7. To link this Range Slider to the appropriate data, drag the 'Date' field from the tree, and drop it onto the Range Slider component in the grid.


8. Click on the 'Preview' button on the main toolbar. This opens a preview window that allows you to view and manipulate the Viewsheet as a user.
To view the layout grid in the preview, right-click anywhere in the preview, and select 'Show Grid'. You can then adjust row and column sizes to get a better data view. To remove the grid, right-click anywhere and select 'Hide Grid'.
9. Close the preview window, and return to the design view.
10. In the design view, use the main toolbar to change the fonts, colors, and other visual properties of the elements. (The right-click context menu for each element provides further options.)
11. Click the 'Save' button on the toolbar to open the 'Save Viewsheet' dialog box. Enter “MyFirstViewsheet” as the name, then click 'OK'.

This saves the Viewsheet into the Repository, where you can access it at a later time.
You have now constructed your first Viewsheet.
| << 2 Visual Composer | © 1996-2013 InetSoft Technology Corporation (v11.4) | 2.2 Exploratory Visualization >> |