.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to display reports from multiple lists in SQL Server Reporting Services Report Viewer

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#

Hi All,

  I want to generate report through SSRS from more than one sharepoint lists. To generate report from one list i am using below query:

   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
         <Parameter Name="listName">
   <ElementPath IgnoreNamespaces="True">*</ElementPath>

Please suggest me a query to get results from more than one list like we use joins for SQL tables.

Thanks in advance,

Saurabh Kumar Singh

Mail: saurabhsinghmca@gmail.com

View Complete Post

More Related Resource Links

Does OOTB SQL Server Reporting Services Report Viewer support personalization? If not what are some


I am currently using WSS 3.0 (Sharepoint 2007) and SQL Server 2008 R2 reporting services.  I have upgraded the SSRS Add In from this site so that I'm using a build from Sept 2010:  http://www.microsoft.com/downloads/en/details.aspx?FamilyID=35c3a13f-4b5e-4d4a-86e4-07ee307b9638&displaylang=en.  I restarted IIS and the service for Reporting Services after upgrading the SSRS Add In.  I also verified in Add/Remove programs that the version for the SSRS Add In is now 10.2.400.0.

I can modify and change the title property in the OOTB Report Viewer in a personal view and when I switch back to the shared view the title differs as expected.  However, if I change the value of a parameter in a personal view and switch back to the shared view, the shared view renders with the value from the personal view.

Does the OOTB Report Viewer not support personalization of parameters?  If not, are there any alternatives?  The users of our portal will want to be able to set their own values for parameters which will not affect the shared view.

How to import SQL Server Reporting Services Report Viewer Webpart on web part Page using code in Sha


Hi Every One,

I have use SQL Server Reporting Service in SharePoint integrated mode. I have deployed all reports and data source in SharePoint Document Library using CODE. I need to show those report in “SQL Server Reporting Services Report Viewer” Web Part on Web Part Page, I have created Web Part page by code. But I cannot import this Web Part on Page using Code.

How I can do this by code.


Navaratan Sharma

Add SQL Server Reporting Services Report Viewer webpart on SitePage give error.



i have use Sharepoint Foundation 2010 with VS 2010. i have config  in Reporting Services 2008 R2 SharePoint integrated-mode. when in add  SQL Server Reporting Services Report Viewer webpart  on SitePage it give error message. "The Controls collection cannot be modified becouse the control contains code blocks(i. e. <%...%>)." How i can add this web part on my SitePage?

Navaratan Sharma

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services


Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

Data Points: Designing Reports with SQL Server Reporting Services 2005


Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both Windows® Forms and Web-based applications.

John Papa

MSDN Magazine June 2006

Reporting Services: Deliver SQL Server Reports To SharePoint To Enhance Team Collaboration


The solution covered here includes a custom SharePoint Web service that accepts SQL Server-generated report files and, through the WSS object model, stores the file in the appropriate library for enhanced collaboration possibilities.

Ed Hild

MSDN Magazine March 2006

SQL Server: Display Your Data Your Way with Custom Renderers for Reporting Services


SQL Server 2005 Reporting Servicesis a great tool that offers a centralized approach to storing and rendering reports. It also lets users view and download reports without installing additional software. Plus, reports can be saved in any number of different formats using custom report renderers. In this article, the author will develop one such report renderer that outputs HTML reports, but the skills you'll learn can easily be used to create a renderer for Microsoft Word documents or any other format of your choosing.

James Yip

MSDN Magazine February 2005

Reporting: Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services


SQL Server 2000 Reporting Services--a server-based reporting platform built on the .NET Framework and integrated with SQL Server 2000--lets you easily add reporting from diverse data sources. Using Visual Studio and Reporting Services you can integrate reports from any data source that has an OLE DB, ODBC, or ADO.NET provider into your Web applications. This article explains how it's done.

John C. Hancock

MSDN Magazine August 2004

The report server instance is not configured correctly. Please use the Reporting Services Configurat

Hello All, I am having problem in configuring report server in SharePoint 2010 Central Administration. The Scenario is explained below: We have farm with two Servers with following components installed: 1. APPSERVER : SharePoint 2010, SSRS(2008 R2) and Reporting Services Add in (installed using credentials    (domain/sharepointuser)) 2.  SQLSERVER: SQL SERVER 2008 R2, Report Server Database (installed using credentials    (domain/sqluser)) Steps followed: a. Configured Report Server on APPSERVER with database in SQL SERVER. We browsed the report server url (http://localhost/reportserver) successfully b. Installed Reporting Services Addin on APPSERVER c. In SharePoint Central Administration, Under Reporting Services Integration, we gave the report server web server url as http://localhost/reportserver , authentication as Windows Authentication and credentials which are used to install SQL SERVER (domain/sqluser) d. We also added a new group called WSS_WPG Error is given below: The report server instance is not configured correctly. Please use the Reporting Services Configuration tool to create a report server database in SharePoint integrated mode before setting integration options for this SharePoint Web application. Thanks in Advance  

How to set the IP addresses for teh report server on sql server 2008 reporting services

How to assign IP address to report server on 2008 version, i don't see nothing on IIS. I have installed sql server / report server 2008 on windows 2003 server. I don't see no info in IIS, can you please help, Also how to check the configuration files i remember in 2005 version i still have to open teh configuration file in notepad and do some modifiications with teh http://local to http://IPaddress etc. Thanky ou very much for the help ful info.  

Permission Errors for Users on Home Page only of SQL Server Reporting Services Report Manager

I have spent days now investigating this problem, so any help very much appreciated! I have a remote web server 2003 running SQL Server R2 Express Edition with Reporting Services installed. I use Report Builder 3.0 locally to build report. If I login via Internet to Report Manager Web Page as an administrator I can perform all the expected and required actions, creating new folders and assigning permissions for users etc. I have added a new user "ReportUser" as a Browser of a child folder. If ReportUser longs on to home page, he receives the all too familiar error: User 'XXXXXXXX\reportuser' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. However, if the user starts at the child folder of home page, and then logs in, he sees the expected page, and can run the report!  This is not very satisfactory. How can I allow user to see home page, without an error message, but not be allowed to click on any folders to which he is not entitled? I am now aware that SQL Server R2 Express Edition has many limitations compared with full Editions (fixed roles, cannot manage Report Service from Management Studio etc) , and many of the "solutions" offered on the web just do not apply.   John Walton

I get a rsUrlRemapError when trying to display Reporting Services report in SharePoint



When I try to open/view a report in SharePoint I get this strange error:

The URL, 'http%3a%2f%2fdemo%2f_vti_bin%2fReportServer', cannot be mapped to a public URL in this SharePoint environment. (rsUrlRemapError)

It seems like the URL get encoded somwhere, but where and why??

Everything else seems to be ok. The report renders well when navigating directly to it (not using the Reporting Services web part).

(SharePoint 2010 RTM)



SQL Server 2008 R2 Reporting Services - How to I run a report and save the output as a .pdf on the s


I have the source code for doing what I want to do using a previous version of SSRS.  Since the new release, the service seems to work differently as I can't find any of the methods in the WSDL:

//Validate txtEmail for inputting

lblPrompt.Text="You must enter a valid email address!"

lblPrompt.Text="You must enter a valid email address!"

//Get report

TimeSheet.wdsg_svr003.ReportingService rs=new


Reporting Services Error-The version of the report server database is either in a format that is not


 Hi,I have Configured All Reporting SErvices Through Rep Serv Configuration Wizard


When I type 


on top of Address Bar Of Browser I Am Gettin This Error

  • The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)
PLease Help Me


How to show a "document map" in reporting services 2005 report viewer


Hi there,

I am wondering how to show a "document map" in reporting services 2005 report viewer. Under


it is stated that there should be a document map icon that I can click on to show my report map but this icon does not exist. Is there anything I have to do to enable it?

Best wishes



Problem with Reporting Services -- Report Hangs sometimes, need to restart server



We are having an application in which we generate several kinds of reports. We have one report- person addresses, through which we generate the report for all the people whom we have to deliver the cards. This is one of our most frequently used reports.

Some time back, we started getting problems of reports hanging on blank white page and nothing comes up. We restarted the server and everything wents fine. After some more days, the problem occurs again and again we restarted the server.

From that time the problem is coming up again and again and everytime we needs to restart server to make it work. But we cant do that every time ..Can anyone please suggest what may be causing it?

Database server: sql 2000

reporting services : Microsoft SQL Server Reporting Services Version 8.00.1062.00

operating system on which report is running: Microsoft Windows NT 5.2.3790.0

Application is build in .Net 2003

Sometimes the problem comes in 2 weeks, and sometimes it comes twice in a week.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend