Lesson 1: Create a sample subscriber database
In this Reporting Services tutorial lesson, you create a small "subscriber" database to store subscription data for your data-driven subscription. When the subscription is processed, the report server retrieves this data and uses it to customize report output. For example, the rows of data include specific order numbers to use for filters and what file format generated reports are in when they're created.
This lesson assumes you're using SQL Server Management Studio to create a SQL Server database.
Create a sample subscriber database
Start Management Studio, and open a connection to an instance of the SQL Server Database Engine.
Right-click on Databases, select New Database....
In the New Database dialog box, in Database Name, type Subscribers.
Select OK.
Select the New Query button on the toolbar.
Copy the following Transact-SQL statements into the empty query:
Use Subscribers CREATE TABLE [dbo].[OrderInfo] ( [SubscriptionID] [int] NOT NULL PRIMARY KEY , [Order] [nvarchar] (20) NOT NULL, [FileType] [bit], [Format] [nvarchar] (20) NOT NULL , ) ON [PRIMARY] GO INSERT INTO [dbo].[OrderInfo] (SubscriptionID, [Order], FileType, Format) VALUES ('1', 'so43659', '1', 'IMAGE') INSERT INTO [dbo].[OrderInfo] (SubscriptionID, [Order], FileType, Format) VALUES ('2', 'so43664', '1', 'MHTML') INSERT INTO [dbo].[OrderInfo] (SubscriptionID, [Order], FileType, Format) VALUES ('3', 'so43668', '1', 'PDF') INSERT INTO [dbo].[OrderInfo] (SubscriptionID, [Order], FileType, Format) VALUES ('4', 'so71949', '1', 'Excel') GO
Select ! Execute on the toolbar.
Use a SELECT statement to verify that you have three rows of data. For example:
select * from OrderInfo
Next step
- You successfully created the subscription data that drives report distribution and vary the report output for each subscriber.
- Next, you modify the data source properties of the report to use stored credentials.
- You also modify the report design to include a parameter that the subscription uses with the subscriber data. Lesson 2: Modify the report data source properties.
Related content
More questions? Try asking the Reporting Services forum.
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho