MSSQL Server Reporting Services: Managing Reporting Services: Data-driven Subscriptions, and External Data Sources for Subscriber Data - Page 5

June 23, 2004

The new database appears among any other databases that were already in existence, as shown in Illustration 10.

Click for larger image

Illustration 10: The New Database Appears (Circled)

Now let's create a table to contain our Subscriber information.

14.  Expand the RS_Subscription database by clicking the "+" sign to its immediate left, from the left pane in the Management Console, as shown in Illustration 11.

Click for larger image

Illustration 11: Expand the RS_Subscription Database

15.  Right-click the Tables node within the expanded database.

16.  Select New Table ... from the context menu that appears, as depicted in Illustration 12.


Illustration 12: Select New Table ...

The Table Designer appears. Here we can easily create columns and other table details.

17.  Add the columns and details depicted in Table 1 to the appropriate places in the Table Designer grid.

Column Name

Data Type

Length

Allow Nulls

Description

Participant

Varchar

50

Unchecked

Subscriber Name

File_Share

Varchar

165

Unchecked

File Share Qualified Name

Identification_No

Varchar

50

Unchecked

Associate ID Number

Media_Format

Varchar

50

Unchecked

Report File Type

Parameter

Varchar

50

Unchecked

Filter Parameter

Table 1: New Table Construction Details

Once the information in the table is entered, the Table Designer grid will appear as shown in Illustration 13.


Illustration 13: The Completed Table Designer Grid

18.  Click the Save icon, depicted in Illustration 14, to name and save the new table.


Illustration 14: The Save Icon

The Choose Name dialog appears.

19.  Enter the following as the table name:

SubscriberDetails

The Choose Name dialog appears as shown in Illustration 15.


Illustration 15: The Completed Choose Name Dialog

20.  Click OK.

21.  Close the Table Designer grid by double-clicking the Enterprise Manager icon to the left of the Save icon (circled in Illustration 16).

NOTE: Be sure to double-click the correct icon - the one on the Table Designer bar, not the one on the Management Console bar, as is noted in Illustration 16.


Illustration 16: Closing Table Designer

Once Table Designer closes, we see the new SubscriberDetails table, among the system tables of the RS_Subscription database, as shown in Illustration 17.


Illustration 17: The New Table Appears ...








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers