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

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

VS2010 Reportviewer - subreport - web server

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :ASP.Net
Hi all,I have ASP.NET web application(vs 2010). I'm trying to use subreport with reportviewer. The report is working with my machine, it returns both the main and sub report. But when I deplyed to web server, the main report display, but not the subreport and no error indicate. I did something like this with VS2005 and deployed to web server without any problems. Here is my coding:Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load      Dim ReportViewer1 As New ReportViewer        Dim rptDataSourceMain As New ReportDataSource("dsSRC", GetDataSet("p_SRC_completed_main").Tables(0))        With ReportViewer1            .ProcessingMode = ProcessingMode.Local            .AsyncRendering = False            .LocalReport.ReportPath = "content\SRC.rdlc"            .LocalReport.DataSources.Clear()            .LocalReport.DataSources.Add(rptDataSourceMain)        End With        ' HANDLE the sub-report        AddHandler ReportViewer1.LocalReport.SubreportProcessing, AddressOf SetSubDataSource        ReportViewer1.LocalReport.Refresh

View Complete Post

More Related Resource Links

why can't i run silverlight w/ wcf in iis but VS2010 built-in ASP.Net development server?

 Both VS200 and IIS are in my local machine. Suppose they have the same permission. I create a silverlight4 w/ wcf ria service project. The project runs well in VS2010 built-in ASP.Net development server. It doesn't work well after i publish it to IIS. I only can see its static content but not the .svc. i try to browse the .svc, it always show HTTP 500 error. I doubt if i do not open the asp.net runtime setting sth in IIS? Thanks!

Do SharePoint 2007 and VS2010 have to be installed to the same Windows Server machine?

For WSS 3.0 development using VS 2005, I learned that we need to install VSeWSS to the Windows Server where the WSS 3.0 was installed.  For MOSS 2007 development using VS 2010, do we need to have VS 2010  nstalled to the same Windows Server?  Thanks, Jeffrey

How to force MVC Projects setup to use IIS as web server IN VS2010 Professional

Hi..I am creating a secondary app that will interact with some controller actions in MVC Site thus i need it running when i boot my Dev PC.   The problem is that VS2010 Pro always seems to create the site using the inbuilt VS Web Server. How can i change this setting?   Thanks

ReportViewer not working in vs2010 framework4

I cannot get my reports to work when combined with a master page. I have a webpage with a reportviewer that has always worked in VS2008 framework3.5.  However, When I rebuild this for vs2010 it looks like this: <%@ Page Title="" Language="VB" MasterPageFile="~/TopMenu.master" AutoEventWireup="false" CodeFile="TestControl2.aspx.vb" Inherits="TestControl2" %> <%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">     <asp:ScriptManager ID="ScriptManager1" runat="server">     </asp:ScriptManager>         <rsweb:ReportViewer ID="ReportViewer1" runat="server" CssClass="CornwallReports"             Height="475px" ProcessingMode="Remote" Width="900px">             <ServerReport ReportPath="/Cornwall/Reports/FindSales"      &

Help - Serious ReportViewer Problem upon upgrade to VS2010

I upgraded from VS2008 to VS2010 and none of my reports work! First, I had to replace all the existing ReportViewer controls with new ones.  Then, when the page finally runs, it is stuck in a loop: I see the "Loading..." word and icon while the ReportViewer is loading, then a quick flash, and the page loads again! What's going on?  What am I missing that should obviously be changed to make these ReportViewers work?  These reports were designed in VS2005/2008, and have been in production for several years. Please help - I have a screaming client... (I know, we all do...)

Upgraded to SQL Server 2008 Express R2 64bit and now all my VS2010 db apps won't run

I am running WIN764bit, VS2010 and just "upgraded" from SQL server 2005 to SQL Server 2008 Express R2 64 bit.  When I went back into VS2010 and tried to run and test several database apps that I have developed, I find that I keep getting the error "Failed to generate a user instance of SQL server due to a failure in starting the process for the user instrance".  I have read a lot of threads here but I am not getting anywhere.  I can create a new SQL Server database, but can't find any of my existing .dbo connections and can't open any of the .mdf's from within Server Explorer (VS2010).  Any ideas? BTW the install went fine. And I have User Instance set to True in VS2010.

CS0102 Error on ReportViewer reports using VS2010 Professional

I am trying to build reports using the ReportViewer feature in Visual Studio 2010 Professional and I am encountering the following error when I try to run the aspx page containing the report.Compiler Error Message: CS0102: The type 'SupApps_SecurityDataSet' already contains a definition for '_schemaSerializationMode'The error is stating the issue is on line 27 of the file but I dont see how to view the code on a rdc file in Visual Studio.HERE IS THE CODE FOR THE ASPX PAGE<%@ Page Language="VB" AutoEventWireup="false" CodeFile="QMDailyJournalReport.aspx.vb" Inherits="reports_QMDailyJournalReport" %> <%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title></title> </head> <body>     <form id="form1" runat="server">     <div>              <rsweb:ReportViewer I

Problem with Subreport in ReportViewer


I'm trying to use the report designer in Visual Studio 2010 for the first time.  It's pretty straightforward and I've got my main report working just fine.  It's a local report (RDLC).

Now I want to add a subreport and I'm having trouble.  I've created the subreport and it runs perfectly on its own, but when I add it to the main report and run the main report the main report works but where the subreport should be is a message which says:

Data retrieval failed for the subreport

followed by the path to the report.  I'm passing the only parameter that the subreport requires from the main report, just specifying a static value for now until I get it working, at which point I'll change it to an expression.  I do have two SQL data sources on my page with the ReportViewer, one which corresponds to the required data for the main report and one for the subreport.  I don't know if this is the right way of doing it but I've tried just using one data source with all of the fields in it instead and that didn't work either.

Tutorials for the report designer and subreports are few and far between but those I can find make it seem very simple and I can't see what I'm doing wrong!

Graphs are not being displayed in ReportViewer after upgrade to SQL Server 2008 R2


I am having a problem with my graphs disappearing after upgrading to Reporting Services 2008 R2.  The graphs are visible if the report is run from the Report Mananger but if the report is viewed from an ASP web app using ReportViewer 9.0 they disappear.  If the report is exported the graphs are there.  This is driving me crazy.

My Report Viewer code from the web page:



and web config http handler:




HELP!!!  Does anyone have any ideas?  I saw the post about u

Report Server project in VS2008 and VS2010


Hi All,

I cannot open my VS2008 Report Server project after installing VS2010 and Framework 4.0 on my machine. How to run those reports now? I still have VS 2008 installed.. Please suggest..

VS2010 ReportViewer with SQL 2005


Please forgive me for the simple question because I'm a newbie and I'm trying SQL Reporting service for the first time EVER.

The more I read online, the more I'm confused.  My setup is this.

VS2010 / SQL 2005 / IIS 6 / ASP.NET 4.0

I created my first report using SQL 2005 and it works great from the report server.

I'm trying to run this report in my aspx page using a reportviewer control.  As soon as I put a reportviewer control on my page, this gets generated in web.config but it's cuasing the below error.  All I did was put the control on the page.  I haven't even changed anything to the control yet.

Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

Source Error:

Line 85: 				<add assembly="Microsoft.Build.Framework, Version=, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
Line 86: 				<add assembly="System.Management, Version=, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>

SQL Server Express 2008 R2 and VS2010


Is anyone using this combination together?

I ask because I have posted previous questions without reply.  There seems to be a compatibility issue with the database in VS once opened up in R2 - any got any experience of this and how to work round it?



How to connect a remote Sqlserver 2008 r2 server with IP address and port? I use SMO and VS2010.


how to write SMO's conn.ConnectionString with IP address and port?

Cannot connect to SQL Server 2008 after Uninstalling VS2010 ultimate and installing VS2010 premium


I installed VS2010 Ultimate to test it out but had license for the VS2010 premium only.  After uninstalling ultimate and reinstalling VS2010 premium, my SQL Server 2008 now refuses to connect to my databases stating: 

TITLE: Connect to Server

Cannot connect to Q9300\SQL200801.


VS2010 Pro and SQL Server 2008 R2 Express




I have installed VS2010 Pro Trial (with the intention of buying VS2010 Pro). If I understand well, during the installation, SQL Server 2008 Express was also installed. I wonder if there are any clear instructions somewhere of how to upgrade from the (existing) SQL Server 2008 Express to SQL Server 2008 R2 Express edition. I have already spent hours researching and I am very confused with the various editions of SQL Server 2008! :( (It took me forever to realize that SQL Server 2008 Express with SP2 is NOT the same as SQL Server 2008 R2 Express since many of the links of the R2 site forward one to 2008 pages!!! :( )

And a side question... Is there a way (that I obviously haven't figured out yet!) to manage SQL Server Express (2008 plain or 2008 R2) from OUTSIDE VS? (I'm an old programmer from the VS6/MSDE era :P )

Thanks for your patience and any responses!

SQL Server 2008 Development problems with Visual Studio 2010 Ultimate uninstall and VS2010 premium i


I installed VS2010 Ultimate to test it out but had license for the VS2010 premium only.  After uninstalling ultimate and reinstalling VS2010 premium, my SQL Server 2008 now refuses to connect to my databases stating: 

TITLE: Connect to Server

Cannot connect to Q9300\SQL200801.


Disable Export Options on ReportViewer using a Server Report


Is it possible to disable export options on a server report in the ReportViewer control without changing the reportserver.config file? 

I have the code to change a Local Report but not a Server Report.  We have a group of reports we only want to be able to export to PDF and TIFF while the other server reports should be exportable in all formats.

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