steps to setup reporting service in sharepoint

Make Report by Reporting Service with SharePoint List

First at all we see what is report by Reporting Service on SharePoint Foundation look like

Can be export the report to Excel, PDF, Word, Tiff, XML, CSV, MHTML

 Now let follow 47 steps to make report by Reporting Service with data from SharePointList then show it on SharePoint as a datasource of Reporting Service Webpart

1. Open SQL Server Business Intelligence Development Studio

2. File ->  New -> Project...

3. Make new project from Report Server project

4. Reports - Add New Report

5. Report Wizard -> Next >

6. JobOrder SPList look like

7. Filling Connection string for SharePointList DataSource

8. Data Source Credentials

9. Select the Data Source -> Next >

10. Unable to connect to data source. Support Windows Integrated Security only

11.  Back to Credentials...

12. Use Windows Authentication (Intergrated Security)

13.Click Next after change Credential to Windows Authentication

14. Query Builder ...

15. Choose JobOrder list then click OK

16. Design the Query -> Next >

17. Choose Tabular then click Next >

18. Choose columns for detail of report then click Next

19. Choose the Table Style then click Next

20. Choose a name for the report then click Finish

21. Click on Preview

22. The first look like of report on Visual Studio

23. View Code of the report

24. The original of SharePointListDataSource

25.Replace DataSource reference by a SharePointList Dataprovider and a ConnectionString

26. Add Document to Share Documents

27. Click Browse...

28. Browse to folder location of the report, choose it then click Open

29. Click OK after choose the report

30. Click Edit icon

31. Click Insert

32. Click Web Part

33. Click SQL Server Reporting

34. Click on SQL Server Reporting Services Report Viewer

35. After choose SQL Reporting Services Report Viewer then click on Add

36. Click on Page

37. Click on Save & Close

38. Click on Report Viewer Web Part Menu

39.  Click Edit Web Part

40. Click on ... to choose the report on Share Document

41. Click Up icon

42.Click on Shared Documents

43. Choose JobOrderReport then click OK

44. Click on Appearance

45. Change width of report webpart then click Apply

46. Click OK at Tool Part

47.The JobOrder Report look like on SharePoint Foundation 2010

48. More information that how to integrate Reporting Service With SharePoint 2010
Intergration Reporting Service with SharePoint 2010 by 84 steps / Giải pháp miển phí tích hợp Reporting Service với SharePoint

49. Download code and list template
Report code: http://www.divshare.com/direct/15579552-347.zip
List template: http://www.divshare.com/direct/15579557-002.stp

God bless us!
Thomas Trung Vo
-------------------------------------------------------------------------------------------------------

You can either use filter or CAML where clause to set the query condition. Add parameter in reporting service and set it in reporting service webpart programmatically.