...

8.1 Report Subscription Details

Schedule the report delivery to client

8.2 Steps to configure the report subscription

9 Query Fixes

9.1 Query

...

IF NOT EXISTS (SELECT * FROM OperationalReport WHERE ReportName = 'WIOAMasterReport' AND CategoryId = 12)

BEGIN

INSERT OperationalReport (ReportName, DisplayName, ShowReport, CategoryId)

VALUES('WIOAMasterReport', 'ETA9173', 1, 12)

END

GO

9.2 Query Changes

Changes

#1. Open the Dataset

#2. Get the query

#3 Open it in SQL enterprise manager

#4 Add parameters or modify the query as per the requirement

10 Deploying SSRS Reports

...

Note: Above list may have more tables . Need to update

12.

...

Access/Deployment Request

#1.Send an email to Vinayak CC to Vishy

#2. Instance Name in which Report has to be deployed, Query has to be added for new report and Report Name