SSRS Report
- Sharmendra Vishwakarma
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 | 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.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 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 Modifications to Existing Reports
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 | Header Color | #6099a8 : Background Color |
| 2 | Font Size : Header | Arial, 14pt, Default, Default, Default |
| 3 | Font Size : Data Items | Arial, 10pt, Default, Default, Default |
| 4 | Standard Filters ( List of Fields) | EmployeeId,HideHeader,DateCriteria,StartDate,EndDate |
| 5 | Standard Sorting ( List of Fields) | Based 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 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
#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
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