ssrs and sharepoint there and back again
DESCRIPTION
A journey or quest to install and configure SSRS and Sharepoint for a reporting solution for major SAP integration project.TRANSCRIPT
![Page 1: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/1.jpg)
SSRS and SharePoint - There and Back Again
Terry Bunio
![Page 2: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/2.jpg)
![Page 4: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/4.jpg)
![Page 5: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/5.jpg)
![Page 6: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/6.jpg)
![Page 7: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/7.jpg)
![Page 8: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/8.jpg)
![Page 9: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/9.jpg)
![Page 10: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/10.jpg)
![Page 11: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/11.jpg)
![Page 12: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/12.jpg)
![Page 13: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/13.jpg)
![Page 15: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/15.jpg)
![Page 16: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/16.jpg)
![Page 18: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/18.jpg)
![Page 19: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/19.jpg)
![Page 20: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/20.jpg)
![Page 21: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/21.jpg)
Evaluation Criteria Weight
MBC Required Functionality 350
Cost 100
Future Commercial Viability 100
High Availability 50
Scalability 50 Product Track record/Future stability 50
Technical Functionality 350
Architectural Standards and Connectivity 50
DBMS standard functionality 100
Data Warehouse standard functionality 150 Security/Encryption 50
DBMS Management Functionality 50
Ease of Maintenance/Management 30
Database Configuration 20
People and Future Flexibility 50
Future Migration/Flexibility 20
Evaluation Criteria Weight
Standard Technology/People Availability 30
Performance Functionality 200
Bulk Load Performance 20
Bulk Update Performance 20
Bulk Delete Performance 10
Basic Query Performance 20
Cross Product Query Performance 20
Sub Query Performance 20
Parallel Query Performance 20
Analyt ical Query Performance 20
Indexed Update Performance 20
Indexed Delete Performance 20
Non-Indexed Update Performance 10
![Page 22: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/22.jpg)
![Page 23: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/23.jpg)
![Page 24: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/24.jpg)
![Page 25: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/25.jpg)
MSSQL Excel SSAS SSMS DQS Report
Builder Visual
Studio
Share
Point
SSRS SSIS MDS Power
View
Power
Pivot
![Page 26: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/26.jpg)
![Page 27: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/27.jpg)
![Page 28: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/28.jpg)
![Page 29: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/29.jpg)
![Page 30: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/30.jpg)
![Page 31: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/31.jpg)
![Page 32: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/32.jpg)
![Page 33: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/33.jpg)
![Page 34: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/34.jpg)
![Page 35: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/35.jpg)
![Page 36: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/36.jpg)
![Page 37: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/37.jpg)
![Page 38: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/38.jpg)
![Page 39: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/39.jpg)
![Page 40: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/40.jpg)
![Page 41: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/41.jpg)
![Page 42: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/42.jpg)
![Page 43: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/43.jpg)
![Page 44: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/44.jpg)
![Page 45: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/45.jpg)
![Page 46: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/46.jpg)
![Page 47: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/47.jpg)
![Page 48: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/48.jpg)
![Page 49: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/49.jpg)
![Page 50: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/50.jpg)
![Page 51: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/51.jpg)
![Page 52: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/52.jpg)
![Page 53: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/53.jpg)
![Page 54: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/54.jpg)
![Page 55: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/55.jpg)
![Page 56: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/56.jpg)
![Page 57: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/57.jpg)
![Page 58: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/58.jpg)
![Page 59: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/59.jpg)
![Page 60: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/60.jpg)
![Page 61: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/61.jpg)
![Page 62: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/62.jpg)
![Page 63: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/63.jpg)
![Page 64: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/64.jpg)
![Page 65: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/65.jpg)
![Page 66: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/66.jpg)
![Page 67: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/67.jpg)
![Page 68: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/68.jpg)
![Page 69: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/69.jpg)
![Page 70: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/70.jpg)
![Page 71: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/71.jpg)
![Page 72: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/72.jpg)
![Page 73: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/73.jpg)
![Page 74: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/74.jpg)
![Page 75: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/75.jpg)
![Page 76: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/76.jpg)
![Page 77: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/77.jpg)
![Page 78: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/78.jpg)
![Page 79: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/79.jpg)
![Page 80: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/80.jpg)
![Page 81: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/81.jpg)
![Page 82: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/82.jpg)
![Page 83: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/83.jpg)
![Page 84: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/84.jpg)
![Page 85: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/85.jpg)
![Page 86: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/86.jpg)
![Page 87: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/87.jpg)
![Page 88: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/88.jpg)
![Page 89: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/89.jpg)
![Page 90: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/90.jpg)
![Page 91: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/91.jpg)
![Page 92: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/92.jpg)
![Page 93: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/93.jpg)
![Page 94: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/94.jpg)
![Page 95: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/95.jpg)
![Page 96: SSRS and Sharepoint there and back again](https://reader033.vdocuments.us/reader033/viewer/2022060115/557ad111d8b42add288b4def/html5/thumbnails/96.jpg)