Creating a SQL Subscription Control

  To create a SQL subscription control for a SQL Spreadsheet:

1. Start Web Analysis Studio.

   You must open a document containing a SQL Spreadsheet or create a SQL spreadsheet after entering Document Designer.

2. Select File , then New, then Document.

   The Document Designer is displayed.

3. Drag the SQL Subscription Object icon from the component toolbar to a document panel.

4. Select the SQL spreadsheet data source for the subscription object.

   The Select Column dialog box is displayed, prompting the user to select a column from the relational data source. The members of this column populate the drop-down list of the control.

   Select the asterisk character (*) to return all column members.

5. Select the relational data source column, and click OK.

   The SQL Subscription Control is displayed on the document panel. The control functionality takes effect when you return to Analyze mode.