REPORTING SERVICE IN SHAREPOINT 2010

Step one:

Open SQL Server Business Intelligence Development Studio

Step two:

Click new add new project and add Report Server Project.

Step Three:

Right Click on Shared Data Source and click Add New Data source to add connection.

Step four:

In General tab add the Name for the Data Source

Select Type as XML

Add connection String as

http://Site/_layouts/_vti_bin/Lists.asmx

Step five:

In Credentials tab select the Integrated Security...

Step six:

Right click on Reports and Click on Add New Report

Step Seven:

Give the Report name and click next.

Then type the Query String code as given below…

<Query>

<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>

<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">

<Parameters>

<Parameter Name="listName">

<DefaultValue>{LIST GUID}</DefaultValue>

</Parameter>

</Parameters>

</Method>

<ElementPath IgnoreNamespaces="true">*</ElementPath>

</Query>

Step Eight:

Add the page> to add the heading for the Reporting Service

Step nine:

Generated Report Screen Shot

Step ten:

By right clicking the project enter the

Target Data Source Folder

Target Report Folder

Target Server URL

Finally Deploy to the server .