Posts

Showing posts with the label Ian Morrish

Sharepoint & SSRS Integration

Notes from Ian Morrish's talk at TechEd NZ '09. SQLServer 2005 R2 - deep sharepoint integration Light up reporting experience (that's my note, and no, I don't know what I meant here either...) Report server in sharepoint mode Reporting services sharepoint add in New in SQLServer 2008 Data driven subscriptions Support for URL parameters Support for RS management tools in sharepoint mode Integration benefits Single user interface Use SP deployment topologies to distribute reports SP features such as workflows, versioning, collaboration are available Reporting authoring tools can publish direct to SP Report subscriptions can be delivered via SP Reports are executed in report server to leverage all its enterprise capabilities Limitations No report manager No linked reports No Sharepoint SSO Anonymous enabled web apps are not supported Default zone only Architectural decisions to make Sharepoint topology SQL topology Security - NTLM / Kerberos Misc Notes Demo samples availa...