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.
...
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) | Based on requirement | |
| 76 | 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
...
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