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


Comments

Post a Comment

Popular posts from this blog

Autism Acceptance Month 2024: Neurodivergence in the workplace

-
Image
It's amazing how quickly April comes around each year when you're AuDHD and have a fleeting grasp on time, but here it is, April again, and time for Autism Acceptance Month .   Something I'm quite passionate about since being diagnosed, is making work a less stressful place for those of us who are neurodivergent. I do this through being open about my diagnosis and by giving presentations to help others understand  what  neurodivergence is. April is a great time to do this and my employer, Envato , actively encourages creating a more inclusive workplace. Yesterday I ran a presentation at work to a large group of folks who were interested in finding out what neurodiversity is, the impacts, and how we can help make the workplace a safer and more inclusive space.  The presentation is freely  available in my Google Drive  if anyone wants to download it and adapt for their own use. How does an AuDHD person, ak...
Read more

What is a geek?

-
Someone raised an interesting point on Monday night at a GGD dinner and I feel they have missed the entire point of Girl Geek Dinners and have also, with their comments, seriously undermined other women who are looking to come out of their shell and interact with other 'geeks'. If you don't agree with what we're doing then don't come to a Girl GEEK dinner, and certainly don't turn up and throw cold water on people, make belittling comments and then moan that it was too technical and you didn't enjoy it. So what is a geek? There seemed to be some confusion. These women throwing around the derogatory comments seem especially confused. So let's refresh everyones' minds. You don't need to be in IT to be a geek folks! It's not an exclusive club limited to women who don't baulk at the thought of writing code. We're a diverse crowd and we celebrate each others geekiness, even if it isn't something we're into. We certainly ...
Read more

The state of NZ internet

-
Image
Following a couple of tweets earlier today stating that our Internet in NZ is somewhat better than we folk who complain think it is, I decided to do a bit of my own research.    I've found in the past that many 'facts' stated in newspapers are outrageously wrong as journalists have a tendency to misread or misrepresent data in order to create a good headline, this means I like to dig around and find out facts for myself as basically I don't trust journalists as far as I can throw them. So, what was it that got my blood boiling this morning?  Someone stating that 80% of NZ internet users get speeds greater than 10Mbps.  What a load of tosh!   Yes, the capability may exist and the telecoms may tell us that they're providing these speeds, but we're certainly not getting these speeds.   I decided to dig further and use an Internationally recognized set of stats to find out the truth... you too can find out stats for yourself right here:   http://www...
Read more