Integration of RS with Sharepoint

Good Day ,

May I know if there is any sites which explains the integration of RS with SPS?

Regards

Alu

Basically, I would like a user using the SPS to query and generate a report....with or without RS?

Regards

Alu

|||

You need to use a report viewer web part

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx

|||

thanks.

does this applies to sql 2005?

|||Yes. There may be minor differences but on the whole it still applies|||

without using report viewer/exploroer from RS web part...is there other means of accessing sql server database directly from SPS (without going thru RS)?

Regards

Alu

|||You can utilise URL access to the report server or query the web service directly|||

With SQL Server 2005 Service Pack 2, we will allow for you to publish reports directly to SharePoint 2007. I will blog on this soon at http://blogs.msdn.com/bwelcker.

|||

correct me if i am wrong ...report server is part of the RS package...and does it means that the service pack 2 can do without RS and generate reports directly from SPS?

Thanks.

Regards

Alu

|||

Hi can anyone explain why do we need an RS as a layer between db and sharepoint when we can directly code or using infopath or generate the required report?

Regards

Alu

|||

I find RS quite handy as middleware between SPS and SQL

we have SPS 2003, RS2005, SQL2005 and with lack of security in SPS 2003, we can customize security in RS per report/folder/group, etc...

Plus, having RS in the middle means you should be able to move the frontend SPS, or the backend SQL easily, as long as RS stays the same (we have SPS, RS, SQL on 3+ different servers)

Plus, designing reports in VS 2005 is much easier, like Crystal Reports

There are reasons why reporting software exists (or why people use Crystal Reports)

|||

May I know the means for communicating the to the database from Sharepoint to generate reports based on the input by the users in Sharepoint sites?

Regards

Alu

|||In this scenario, SharePoint does not talk to the data source directly. It talks to the Report Server (through web services), which, in turn, talks to the database to get the data. The Report Server then processes and renders the report and returns the output to SharePoint.|||

Hi I have just tried the Report Designer from VS2005 and depoly to RS..and it seems like whenever I have a parameter to be passed by the user interface..it will create a 'txtbox' on top of the web page..automatically.

Q1: What about controls like combo boxes and checkboxes ..is it possible to create that kind of a user input interface as well? ( where combo boxes data are retrieved from the database. ( and if its possible..all codings are done in xml ie VS2005 or asp.net 2.0)

Q2: Is the format of the user input interface a fixture? ie in position context. Can we reorganised the position to a desired one? (again some kind of coding is needed somewhere?)

Thanks.

|||

By the way I have put up a new thread regarding a issue on my RS and sql server2005..not sure if I have put up the right post on the right track...:) It happens that I have installed RS on a windows server 2003 and the db on my client machine. From WS2003, I could see my db and can connect sucessfully (have add the browser service and sql server serivces on the Exception tabs under firewall) However when i try to gerenate reports from my own machine, I hit the error...Cannot connect to the <databasename>....Seems like the configuration settings are wrong...been trying to look for the right Web.Config and not sure where it could be found :( ...since I find many of this files in different location:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=875380&SiteID=1

Regards

Alu