March 15, 2011 at 10:57 am
Hi all
I have never used report builder and am finding myself coming up against some issues with it. Does Reportbuilder get installed with SSRS? My deployment is integrated with Sharepoint yet I am unsure what to configure in the Server defaults section?
Any tips on where to start with this are welcome.
Many thanks
March 23, 2011 at 6:57 am
Report Builder is a separate (Free) download from MS.
March 23, 2011 at 7:34 am
Report builder comes with SQL 2008(R2) if you are running in Sharepoint integrated mode then you need to setup a library with type of Reports and then when you click on Documents and new you will get the option to create a report builder report , this will download the report builder application to the desktop temporarily and allow the user to build reports
March 23, 2011 at 8:00 am
Hi thanks for the replies. This is SQL 2008 R2 in integrated mode. I should say I have got a little further with this and in fact am trying to get the click once functionality to work. However my users are not on the domain and are required to authenticate to allow access to Sharepoint.
Looking at the following articles;
http://msdn.microsoft.com/en-us/library/ms365173(v=SQL.105).aspx
and
http://msdn.microsoft.com/en-us/library/cc281309.aspx
There only seems to be ways around this if running in native mode i.e. change to basic authentication and alter config files. If running in Integrated mode there seems to be no way round this other than being in the same domain or switching off all authentication to the Sharepoint site.
Does anyone know a way round this as I we can't switch off authentication nor will the users be in the same domain?
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply