.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

Local Report - nested objects

Posted By:      Posted Date: August 27, 2010    Points: 0   Category :ASP.Net


I trying to use Object data source for my local report. But the problem is that the datasource is having nested objects and I am not able to access the properties of the nested object.

I tried using =Fields!HomeAddress.Value.Zip as mentioned on this site


but couldn't get it working. Its returns #Error for this field.

I am using visual studio 2010 for developing this report

Please help.






View Complete Post

More Related Resource Links

Status of Accessing Nested Objects in Data Source of Local Report Does Not Function


We recently upgraded out platform to .NET 4.  We are also using Microsoft Reporting dlls.  Unfortunately, we found that the upgrade broke all of our reports.  Researching the cause, we found this article:


It seems that this issue has been open for some time now and I have not seen a good workaround (except for the shim class which is not really feasible for us).  Can I please get a status update for this?  Is there some other type of resolution?

Thank you,

Benjamin Strum 

Ben Strum

Local Report - nested objects



I trying to use Object data source for my local report. But the problem is that the datasource is having nested objects and I am not able to access the properties of the nested object.

I tried using =Fields!HomeAddress.Value.Zip as mentioned on this site


but couldn't get it working. Its returns #Error for this field.

I am using visual studio 2010 for developing this report

Please help.






Adding a Chart to a Local Report


Dear All

I have created a report as a local report which looks like this:

I'm trying to add a chart to this report and I'd like it to display something like this (so sorry for the crude drawing):

It seems like it should be quite straight forward but I've tried dragging the fields into the chart all different ways and can't make it happen. I'm using Visual Studio 2010 and here's what my list of fields from the dataset look like:


I thought ObservationYear would be the series and all the other fields would be the data but this doesn't work. It produces a chart like this which wasn't what I was hoping for:

Please could you help me understand what it is I'm doing wrong? I'm very grateful for any help/advice you might be able to provide.

Kind regards








Setting Local Report Data Source

I am a college professor and am updating my undergraduate database course to use Reporting Services as the reporting tool.  The student labs cannot run IIS so I assume that using server-based reports is out and am looking at using local reports and the VB ReportViewer control. For several reasons (waaayyy too long to list here) I do not wish to use the drag-and-drop datasets that seem to be the core of the ADO.Net 2005 architecture.  Instead I prefer to create connections, commands, and datasets in code and to set data binding and manage data updates in code.  All command objects map to SQL Server stored procedures. I need to be able to do the same thing with reporting services local reports but have run into a brick wall in getting the report and/or report viewer to recognize a dataset table created in code. I would like to do the following (which worked very well in VB 2003 using Crystal Reports): 1. Design report--I am willing to accept the requirement to manually set the Value property of controls since I don't want to set data sources to .xsd files. 2. Instantiate a report object at run time and set it's data source to a dataset table.  The underlying query that fills the table would have to contain all columns needed by the report's controls. 3. Set the report object to be the LocalReport for a ReportViewer control. Can anyone point me to a tutorial or walk-through tha

Bug report: MouseMove on document fails over disabled objects.

I found a bug in the event handler code of the client library related to document-mousemove and disabled DomElements. Steps to reproduce: 1. Add an input button to the page and disable it:               <input type="button" id="Button1" value="Button 1" disabled="disabled" />  2. Attach a mousemove event to the document in the init event of the application:              Sys.Application.add_init(function() { $addHandler(document,'mousemove',function(e) { }); }); 3. Run the page in IE and move the mouse over the disabled button. An exception is thrown:             Microsoft JScript runtime error: Sys.ArgumentException: Value must be a DOM element. Parameter name: element This problem occurs because the event target is not null, but an empty object. The DomEvent handler tries to get the location of the element, but fails when it realizes that this is not a DomElement (Since MSAJAX doesn't check for argument types in non-debug mode, it there tries to get a property of the object that doesn't exist which fails too). Because of IE's buggy mouseover/out eventhandlers, attaching a mousemove event to the document is

Problems deploying Report in Local Server (localhost)


OK, I'm kind of new to SQL Server 2008 and I'm having issues trying to deploy a report in my local server.


Basically, I installed SQL Server 2008 R2 in my personal desktop and because of this, I thought no Service Account were necessary since I was going to be the only one accesing it; anyway; I've created a set of reports and everything works fine; but when I try to deploy them, they won't go through.

I open a browser and type http:\\localhost\reportserver and it actually requests me for a password; the username is already populated, which is the name of my computer, but then for the password, I didn't set up any password for anything, during the installation and if I put my computer password, it doesn'y work either, after three attemps, the browser simply goes blank.

I'm sure this might be a very basic issue, but I've been trying to look for answer, online, through forums etc; and no good luck yet...


Thanks in advanced for all your help!



In SSRS 2008, after export to Excel report loses nested visibility groups


I have a report  created in SSRS 2005 which is running on our new SSRS 2008 box.  It has 3 nested levels of visibility so the recipient can click the twist tie to view different levels of detail.  Each Zone has many Districts and each District has many Stores.  The report renders displaying the summary of the Zones.  If you click on the twist tie on the Zone it opens up a list of Districts.  If you click on the twist tie on a district, it opens up a list of stores.  If you click on the twist tie on one of the stores, you get the actual details of all repair orders submitted for that store.

The report renders fine in report manager.  The report has a subscription set up to run monthly that exports the results to Excel and emails them to our client.  The problem is when the report exports to Excel the twist tie exists on the Zone, but it missing on each of the Districts and Stores.  The client is not happy about this.  This report contains large amounts of data and is very combersome without the visibility grouping working properly in Excel.

I tried converting the report to SSRS 2008, but that did not solve my problem. 

Is there anyway to fix the export process to Excel? 


P.S. I tried to upload the code, but it caused my question to be too many characters

An error occurred during local report processing


My report runs fine until I added a new field ("TradeDate") to the datasource. when run the report, I got the following  error:


 Error 1 The Value expression for the textbox 'textbox68' refers to the field 'TradeDate'.  Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope. C:\Pro1\Allocation.rdlc 1 


I can see the "TradeDate" on the Datasource list on the left pane after i built the project. But it seems rdlc file still catch the previous datasource, not the current one..



Error "OutputStream is not available when a custom TextWriter is used" on Local Report


 Hi, i'm facing this error: "OutputStream is not available when a custom TextWriter is used"


Here's the code:

 internal void RenderReport(ReportViewer reportViewer, HttpResponse response)
            Warning[] warnings;
            String[] streamids;
            String mimeType;
            String encoding;
            String extension;

            Byte[] bytes = reportViewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings);

            String sFileName = DateTime.Now.Ticks.ToString();


            response.Buffer = true;
            response.ContentType = "application/pdf";

            response.AddHeader("content-disposition", string.Format("attachment; filename={0}.{1}", sFileName, extension));

            response.Charset = "utf-8";
            response.ContentEncoding = Encoding.GetEncoding("iso-8859-1");


..The error occurs on the  "response.BinaryWrite(bytes);" section.

The purpose of this code is to generate a pdf report and le the user downlo

report viewer: Adding Image to local report export drop down list


Is there an easy way to add image to the drop down list that is build into the report viewer export list?



An error occurred during local report processing

A report is driven by finding data so if no data is found, there should be a way to report "NO DATA FOUND". The property for the tablix (NoRowsMessage) should be able to function as a method to show this data. Instead, with the value on the properties filled to say "No Data Found" the message does not change. It still says "An error occurred during local report processing" Why does it not show the message listed in the NoRowsMessage property?

An error occured during local report processing. Exception of type 'System.OutOfMemoryException' W


I've been getting this error, randomly when previewing two reports.

It does not seem to be based on report complexity, size, subreports etc. When
reports are deployed to server, they all run fine. I just get the out of memory error locally.

1. I have one version with 2 datasets, and a number of matrix, table and list data regions.
2. I have a second version with only one table data region.
3. There is no custom code, variables, prompts or generally anything other than basic
formatting in the report.
4. Both reports are based on the same SQL table.

I can seem to run the two reports (both based on same SQL table) a few times, and
then they start giving the out of memory error.

I can open other other reports and they preview fine locally.

What I've tried so far to no avail:

1. Deleted the downloaded data before refreshing the two reports.
2. Tried building the two reports before running.
3. Tried changing the process priority to high for devenv.exe.
4. Removed filters in the reports.
5. Changed the physical order of the underlying table.
6. Closed the reports and then re-opened them.
7. Close Visual Studio and Re-Open. This seems to work for a while and then the two
reports start giving the error messages again.
8. Cop

An error occured during local report processing. Index was out of the range. Must be non-negative an


Hi folks,

I'm getting the following error in my report:

'An error occured during local report processing. Index was out of the range. Must be non-negative and less than the size of the collection. Parameter name: index'

I checked all the datasets and they are working fine in query designer.

Could you plese let me know what might be the issue ?

Thanks in advance.

Converting local report from VS2008 to VS2010

I am new to the local reports I have created one report in VS 2008. which has two tables 1st Table has attached to dataset name - dsPRMIQuote_dtblQuotationMain 2nd Table has attached to dataset name - dsPRMIQuote_dtblQuotationPayRoll (both the table contains sub reports).. To view this report I am using Reportviewer 9.0 It is working fine in VS 2008 But my project is moved to VS2010 I just copied reports including xsd files from to VS 2010 In VS 2010 to view this report I am using Reportviewer 10.0 But I am getting following error at Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, PageCountMode pageCountMode, CreateAndRegisterStream createStreamCallback, Warning[]&amp;amp;amp; warnings) at Microsoft.Reporting.WebForms.LocalModeSession.RenderReport(String format, Boolean allowInternalRenderers, String deviceInfo, NameValueCollection additionalParams, Boolean cacheSecondaryStreamsForHtml, String&amp;amp;amp; mimeType, String&amp;amp;amp; fileNameExtension) at Microsoft.ReportingServices.Rendering.HtmlRenderer.ViewerRenderer.SPBProcessingStub.GetNextPage(RPLReport&amp;amp;amp; rplReport) at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.GetNextPage() at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.InitializeReport() at Microsoft.ReportingS

Report view error "An error occurred during local report processing."


I am trying to generate report using RDLC reports but whenever I try to view the report page I get this error (Pls help)

I don't understand why I am getting this error - I am using VS 2010

I am on my local machine and later on I will be running this project on server also - but for now I am developing this project on my local machine.


  • An error occurred during local report processing.
    • The definition of the report 'Main Report' is invalid.
      • The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded.

Local variable scoping in C#

In my previous post, Compiler-generated scopes for local variable declarations, I briefly touched on the issue of multiple meanings applied to the same name. In this post, I'll aim to flush out the compiler's rules with regards to binding names in their local scopes.

Compiler-generated scopes for local variable declarations

I was tasked with understanding and fixing a bug on error reporting with foreach iteration variables the other day, and it got me thinking about local variable scoping rules in C# in general. First, the bug.
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