Assuming you have created a report with the following queries:
Dataset 1:AdventureWorks
SELECT FirstName, LastName, e.Title
FROM HumanResources.Employee AS e
JOIN Person.Contact AS c
ON e.ContactID = c.ContactID
WHERE e.Title IN (@Title)
Dataset2: TitleList
SELECT DISTINCT Title FROM HumanResources.Employee
The report is based on Dataset1:AdventureWorks. The report parameter:Title is automatically set. You need to modify some settings as shown below:
From report manager http://localhosts/reports, you can manually view the report--this is on-demand.
Scheduled report delivery is the report subscription.
First, access the report manager: http://localhost/reports and create the data source connection as follows --stored the User Name and its password in the report server--unattended.
Second, make sure the SQL Server Agent service starts.Third, create a subscription for the report as PDF documents(deliver them to \\\Vision\SQLServer shared folder.
Every 5 minutes, a new report is created.
At the bottom of the screenshot, you notice the Report Parameter Values. You can select different value or values for the report.
If data of HumanResources.Employee table is changing constantly, the reports will reflect the change.
