Report Builder in integrated mode

Hi,

I have an installation with Reporting Services in integrated mode with WSS 3.0, with Reporting Services Add-in for SharePoint.

I have a document library in witch I added a data source to an SSAS database and a Report model on top of this. When I click Add a Report with Report Builder, the report builder opens, but it fails to connect to the model.

There is a dialog window "Select Site or Server "asking for a URL. I put in there http://localhost, but is not working. I am not able to connect to the report model.

I will appreciate any help on what could be the reason or how can I investigate this.

Thanks,

Dan

P.S.

I did the same scenario on the development environment it works from start, without any problems. But now on production ….

Hi Dan

Try using your machine name instead of http://localhost, ie. http://mymachine. There is a known issue with using "localhost" in Reporting Services in sharepoint.

If that does not work, make sure all your permissions are set correctly in sharepoint. Report Builder will only find models to which you have permission.

You can also double check that your model loads by clicking on its context menu in sharepoint and launching Report Builder from there instead of the new menu.

Also SQL SP2 will be available very soon. Please upgrade if you can since the SP2 contains all the latest Sharepoint improvements for Reporting Services.