Not sure if you can do this in service pack 1, but now you can use reporting services with sharepoint. Download reporting services service pack 2 and check out this article on how to haveyour reports in sharepoint Read More...