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.
**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 |
Eckerdtest4
For Eckerd Database and folder name should be same | |||
| 3 | Eckerd (Pre-Prod) | Eckerdtest - Demo Folder: Eckerdtest | https:// |
| 10. |
| 0. |
| 0. |
https://r720DC.hq.empyra.com/ReportServer
Eckerdtest5
| 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 |
https://r720DC.hq.empyra.com/ReportServer
Eckerd(Other Instance) Other instances for Demo | Folder:Pilot_Eckerd |
EmpyraSandBox --
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 |
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
| View file | ||||
|---|---|---|---|---|
|
#2.Add Dataset and parameters as per the use case
#3.Add the tables/visuals
#4.Add storing/grouping as and when required
5.2 Deployment of new report
#1 Deploy RDL file to report server
#2 Create statement an entry for new report in OperationalReport table
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
Note: Need tp get the details (ReportName, DisplayName, ShowReport, CategoryId) from business requirement
#3 Mark has to do the assignment of report for positioning
...
6.1 Steps involved for modification of existing reports
#1.Identify the report which we need to identify
#2.Get the report name using below query
SELECT * FROM OperationalReport WHERE DisplayName like '%WIO%';
#3.Now, need to identify whether report is global or client specific
#4. If report exists in both the folder (global and client specific), go ahead with client specific report and make the necessary change.
6.2 Deployment of existing report
#1 Go to Project Properties and change the Target Datasource Folder and TargetReportFolder
#2.Deploy RDL file to report server
7 Standards for the reports.
...
| Sl No | Standard to Follow | Description | |
|---|---|---|---|
| 1 | Font Header Color | 2 | Header#6099a8 : Background Color |
| 32 | Font Size : Header 4 | Arial, 14pt, Default, Default, Default | |
| 3 | Font Size : Data Items5 | Arial, 10pt, Default, Default, Default | |
| 4 | Standard Filters ( List of Fields)6 | EmployeeId,HideHeader,DateCriteria,StartDate,EndDate | |
| 5 | Standard Sorting ( List of Fields) | 7Based on requirement | |
| 6 | Standard Grouping ( List of Fields) | Based on requirement |
8 Report Subscriptions
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
...
#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
| View file | ||||
|---|---|---|---|---|
|
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