1 SSRS Landscape
LOCAL SSRS Instance → Bitbucket Repo→ Deployment Server(SQL SERVER 2010) → Dev SSRS Reporting Server→ Production SSRS Reporting Server
2 Servers details
| Sl no# | Client Name | 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
| Sl No | Project Name | Description |
|---|---|---|
| 1 |
4 Repository Details
| Sl No | Repository Name | Description |
|---|---|---|
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.
| Sl No | Standard to Follow | Description |
|---|---|---|
| 1 | Font Color | |
| 2 | Header Color | |
| 3 | Font Size : Header | |
| 4 | Font Size : Data Items | |
| 5 | Standard Filters ( List of Fields) | |
| 6 | Standard Sorting ( List of Fields) | |
| 7 | Standard Grouping ( List of Fields) |
8 Report Subscriptions
8.1 Report Subscription Details
8.2 Steps to configure the report subscription
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.Deploy 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
11. List of DB Tables
Note: Above list may have more tables . Need to update