1 SSRS Landscape
2 Servers details
| Sl no# | Instance Name | URL | Description |
|---|---|---|---|
| 1 | Dev Environments WFDemo_Internal | http://pe1950r2/ReportServer_SQLDEV2012 | |
| 2 | Report access: http://pe1950r2/Reports_SQLDEV2012 | http://pe1950r2/ReportServer_SQLDEV2012 | |
| 3 | Eckerd Development http://10.10.0.10/Reportserver_SQLDEV2012 Eckerdtest | ||
| 4 | Eckerdtest - Demo https://r720DC.hq.empyra.com/Reports/Pages/Folder.aspx?ItemPath=%2fEckerdTest&ViewMode=List https://r720DC.hq.empyra.com/ReportServer Eckerdtest | ||
| 5 | Eckerd Live https://r720DC.hq.empyra.com/ReportServer Eckerd | ||
| 6 | Pilot Eckerd -- https://r720DC.hq.empyra.com/ReportServer EmpyraSandbox1
| ||
| 7 | Dev SQL Server http://10.0.0.37/Reportserver -- Live server |
3 SSRS Projects Details
4 Repository Details
5 Creating new Report
5.1 Steps involved for creation of new reports
5.2 Deployment of new report
#1 Deploy RDL file to report server
#2 Create statement for new report
#3 Mark has to do the assignment of report for positioning
6 Modifications to Existing Reports
6.1 Steps involved for modification of existing reports
6.2 Deployment of existing report
7 Standards for the reports.
8 Report Subscriptions
9 Query Fixes
9.1 Query Information
| Sl No | Query | Description |
|---|---|---|
| 1 | 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
10 Deploying SSRS Reports
#1 Check the report in local instance
#2 Publish the report to GIT
#3 Get the updated file in deployment instance. This is the instance where SQLSERVER 2010 is installed
#4. Deployment the report to Dev environment and request Mark to test the report
#5 Post review , change the target settings for that particular project and deploy it to production. Note: This required approval from Mark