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.
**Deploy through VM (10.10.0.80): Need a access
2 Servers details
Note: Reporting server only opens in IE 11
| Sl no# | Client Name | Instance Name | URL | Description |
|---|---|---|---|---|
| 1 | Internal QA | Dev Environments Folder Name: WFDemo_Internal | http://10.10.0.10/Reportserver_SQLDEV2012 | For Internal QA only. |
| 2 | Eckerd (Internal QA) | Eckerd Development Folder: Eckerdtest | http://10.10.0.10/Reportserver_SQLDEV2012 | For Eckerd Database and folder name should be same |
| 3 | Eckerd (Pre-Prod) | Eckerdtest - Demo Folder: Eckerdtest | https://10.0.0.37/ReportServer | For Re-Prod. This is Production Reporting server having this folder. |
| 4 | Eckerd (Prod) | Eckerd Live Folder : Eckerd | https://10.0.0.37/ReportServer | For Production |
| 5 | Eckerd(Other Instance) Other instances for Demo | Folder:Pilot_Eckerd Folder:WFDemo Folder:EmpyraSandbox1 Folder:EmpyraSandBox | https://10.0.0.37/ReportServer | Eckert Staff will do the testing in Pilot_Eckerd |
| 6 | Development SQL Server | Dev SQL Server | ||
| 7 | Internal Development SSRS | yngempyra\developer D@v@lop@r | http://10.10.0.10/ReportServer_SQLDEV2012 -- Dev Server http://10.0.0.37/Reportserver -- Live server | yngempyra: Domain Name for development Report Server http://10.10.0.10/ReportServer_SQLDEV2012 -- Dev Server http://10.0.0.37/Reportserver -- Live serve hqempyra\reportaccount |
3 SSRS Projects Details
| Sl No | Project Name | Description |
|---|---|---|
| 1 | Eckerd | |
| 2 | MCTA | |
| 3 | Workforce Demo | Base Project : All reports from this project should be deployed to other clients. |
4 Bitbucket Repository Details
| Sl No | Repository Name | URL | Description |
|---|---|---|---|
| 1 | oneflow_oneflowssrs | Default branch (workforceDemo) )for report development |
5 Creating new Report
5.1 Steps involved for creation of new reports
#1.Copy the baseline report template and rename it as per the requirement
#2.
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 and permission from Vinayak
11. List of DB Tables
Note: Above list may have more tables . Need to update