Reporting Services and SharePoint 2007

[alanwallace]

I actually have a couple of questions:

1) What is the web part that makes Reporting Services reports available in SharePoint, and how difficult is it to configure and use?

2) Is it possible for SharePoint list selections to be parameter values in a Reporting Services report? For example, if I am looking at a list of suppliers, select one, and now I want to print a report that is limited to that supplier, can the list selection be passed as a parameter to the report?

[agitprop]

1) There is a basic report viewer WP that was available for WSS 2.0. It was really an iFrame (blech). Don't recommend using it. THe newer version requires a very involved installation, and apparently only works (or, maybe, works correctly) for the default AAM URL. This would be a problem for people using ISA for FBA, for example.

2) In theory, yes, but you're really talking about a custom interface for RS. We've done something like this to get around all of the &@#*!%$ x-browser problems with the RS viewer (I mean, why bother having this lousy interface if it's IE only?). It's actually not all that hard, b/c you can call the web services for both RS and WSS to handle the back-end functionality. One of my more junior programmers developed our revised interface, and it's worked pretty well.