My photo
Auckland, New Zealand
Smurf sized geeky person with a penchant for IT, gaming, music and books. Half of industrial duo 'the craze jones'. Loves data, learning new things, teaching new things and being enthusiastic.

Friday, 18 September 2009

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 available from Codeplex
  • Need to install sharepoint object model on report server and WSS/MOSS server
SP Config options
  • After installing SSRS module on Sharepoint, an option appears in sharepoint to configure reporting services
  • Need to grant access between sharepoint and SSRS
  • If you enter an incorrect username/password it won't give you an error, will just return to the entry page again. If you have entered the correct username/password it will take you back to the main config options screen
  • Set up reporting services server defaults
  • Activate report server feature library
  • Create document library
  • Allow management of content types
  • Security errors can often be fixed in RSReportServer.config


No comments: