Documentation :/wiki/spaces/ON/pages/20381934

1 SSRS Landscape

Local Visual Studio 2010 SP1 ( If this version is not available, please use Visual Studio 2012 ) → Push the files to Bitbucket Repo→ If you have SSRS 2010 then deploy to SSRS server directly else login to VM where SSRS 2010 is installed and deploy to Dev SSRS Server→ verify the changes(by Mark)→ deploy the report to Production SSRS Reporting Server.

...

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