MSSQL Server Reporting Services: Managing Reporting Services: Data-driven Subscriptions, and External Data Sources for Subscriber Data - Page 5June 23, 2004 The new database appears among any other databases that were already in existence, as shown in Illustration 10.
Click for larger image 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 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.
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.
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.
18. Click the Save icon, depicted in Illustration 14, to name and save the new table.
The Choose Name dialog appears. 19. Enter the following as the table name: SubscriberDetails The Choose Name dialog appears as shown in Illustration 15.
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.
Once Table Designer closes, we see the new SubscriberDetails table, among the system tables of the RS_Subscription database, as shown in Illustration 17.
|
|
|
The Network for Technology Professionals
Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers
