Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 13 Next »

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 NameInstance NameURLDescription
1Internal QA

Dev Environments

Folder Name: WFDemo_Internal

http://10.10.0.10/Reportserver_SQLDEV2012For Internal QA only.
2Eckerd (Internal QA)Eckerd Development
Folder: Eckerdtest
http://10.10.0.10/Reportserver_SQLDEV2012

For Eckerd

Database and folder name should be same

3Eckerd (Pre-Prod)Eckerdtest - Demo

Folder: Eckerdtest
https://10.0.0.37/ReportServerFor Re-Prod. This is Production Reporting server having this folder.
4Eckerd (Prod)Eckerd Live

Folder : Eckerd
https://10.0.0.37/ReportServerFor Production
5

Eckerd(Other Instance)

Other instances for Demo

Folder:Pilot_Eckerd

Folder:WFDemo

Folder:EmpyraSandbox1

Folder:EmpyraSandBox

https://10.0.0.37/ReportServerEckert Staff will do the testing in Pilot_Eckerd
6Development SQL Server

Dev SQL Server
10.10.0.10
UID= DevEmpOne;PWD= D@XGU2016kyr





7Internal Development SSRS

yngempyra\developer D@v@lop@r


http://10.10.0.10/Reports/Pages/Folder.aspx

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 NoProject NameDescription
1Eckerd
2MCTA
3Workforce DemoBase Project : All reports from this project should be deployed to other clients.


4 Bitbucket Repository Details

Sl NoRepository NameURLDescription
1
oneflow_oneflowssrs
Default branch (workforceDemo) )for report development



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 NoStandard to FollowDescription
1Font Color
2Header Color
3Font Size : Header 
4Font Size : Data Items
5Standard Filters ( List of Fields)
6Standard Sorting ( List of Fields)
7Standard 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 NoQueryDescription
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




12. SOP : Access of Instances






  • No labels