1 Servers details
| Sl no# | Instance Name | URL | Description |
|---|---|---|---|
| 1 | Dev Environments WFDemo_Internal | http://pe1950r2/ReportServer_SQLDEV2012 | |
| 2 | Report access: http://pe1950r2/Reports_SQLDEV2012 | http://pe1950r2/ReportServer_SQLDEV2012 | |
| 3 | Eckerd Development http://10.10.0.10/Reportserver_SQLDEV2012 Eckerdtest | ||
| 4 | Eckerdtest - Demo https://r720DC.hq.empyra.com/Reports/Pages/Folder.aspx?ItemPath=%2fEckerdTest&ViewMode=List https://r720DC.hq.empyra.com/ReportServer Eckerdtest | ||
| 5 | Eckerd Live https://r720DC.hq.empyra.com/ReportServer Eckerd | ||
| 6 | Pilot Eckerd -- https://r720DC.hq.empyra.com/ReportServer EmpyraSandbox1
| ||
| 7 | Dev SQL Server http://10.0.0.37/Reportserver -- Live server |
2 SSRS Projects Details
3 Repository Details
4 Creating new Report
4.1 Steps involved for creation of new reports
4.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
5 Modifications to Existing Reports
5.1 Steps involved for modification of existing reports
5.2 Deployment of existing report
6 Standards for the reports.
7 Report Subscriptions
8 Query Fixes
8.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 |