.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

Error while Report Processing :

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :ASP.Net
Hi Friends,               In client report server i have deployed reports. I have given access to around five people. Some times the report executes fine but some times it throws error sayingAn error occurred during client rendering.An error has occurred during report processing.Query execution failed for dataset 'dataset name'.For more information about this error navigate to the report server on the local server machine, or enable remoteI have tried all the possibilities that i know, but still the error persists.I am generating a parameterized report. The data is being loaded through a stored procedure. Can any one please shed some light on this issue. In developer machine it is working fine only in client network i am facing this issue.Database : SQL 2000SQL Report Server : 2008Any help would be appreciated.Regards,Anish 

View Complete Post

More Related Resource Links

Error processing report with embedded subreport while leveraging interactive sorting in main report.


This error only occurs with the Report Viewer v10 control...fine with v9 and occurs on both SQL Server 2008 SP1 CU9 and 2008 R2.  I have a report that has an embedded subreport object, and the subreport renders properly until I click on any textbox with interactive sort enabled in the main report...at which time I receive the following error message in the subreport object:


reportrendering!ReportServer_0-2!d98!10/06/2010-11:38:22:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'FilterList', located at: Common_SubReport_FilterList., ;

 Info: Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'FilterList', located at: Common_SubReport_FilterList.

processing!ReportServer_0-2!d98!10/06/2010-11:38:22:: e ERROR: An error has occurred while processing a sub-report. Details: One or more parameters were not specified for the subreport, 'FilterList', located at: Common_SubReport_FilterList. Stack trace:

   at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.CheckRetrievalStatus(Status status)

   at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.RetrieveSubreport()


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..



An error has occurred during report processing.(rsWindowsIntegratedSecurityDisabled)


Hello Friends,

         I am Ali,

1. Created Group(Administrator) and  User(Staff) in Report Server.

2. Enabled 'Remote Errors' in Report Server Through SQL Management Studio.

3. Configured Reporting Services to Sharepoint Integrated mode.

4. Content Types Enabled in Sharepoint Library .

5. Report prepared using with Report Builder:

    DataSource1:Connection Stiring in XML type: http://<ReportServerName>/sites/<siteName>/_vti_bin/lists.asmx

                              Selected Credentials as: Use Current Windows user. Kerberoas Delegation might be Required.

                              and Published this Report to http://<server name>/ReportServer 

6. Uploaded .rdl file ('ApplicationForm.rdl') in Sharepoint Library.

When i was Click on 'Applic

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.

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.

An error has occurred during report processing. (rsProcessingAborted)


Hello  all,

I'm using Sqlserver 2008 R2 Developer edition and i've created the small report and it is working in my computer , when I'm browsing form another computer it is not working  for another user and I have  give full access.

  • An error has occurred during report processing. (rsProcessingAborted)
    • Cannot create a connection to data source 'MyDB_TEST'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Regards, Vik

Report viewer error


  • An error has occurred during report processing.
    • A data source instance has not been supplied for the data source "PatientDetailsReport_DataTable1".

  • i am using two to three rdlc reports in my page for single report viewer when i first load the page i got the output in reportviewer but when i try to load other rdlc report then am getting the above mentioned error.i cleared all the datasources for the report viewer before giving new datasource but am getting the same error pls someone help

Error Message when trying to open crystal report


Logon failed. Details: 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "DATA" requested by the login. The login failed. Error in File C:\Windows\TEMP\NewQuote {573CE511-64B7-4161-B9DF-0E58EB1EDA19}.rpt: Unable to connect: incorrect log on parameters.

I get the above message when loading the crystal report from the Intranet via IIS but it works fine from the localhost the report loads ok and picks up my parameters.  This is my Code behind Page.

Protected Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles CrystalReportViewer1.Load

        Dim Count As Int32
        Count = Int32.Parse(Label1.Text)

        Dim ConnInfo As New ConnectionInfo
        With ConnInfo
            .ServerName = "\\Server1\Sqlexpress"
            .DatabaseName = "DATA"
            .UserID = "sa"
            .Password = "1181

Crystall Report error VS2010



i write a site and get this error, i using VS2010.

  • An error occurred during local report processing.
    • The definition of the report 'Modules\Report1.rdlc' is invalid.
      • An unexpected error occurred in Report Processing.
        • Could not load file or assembly 'Microsoft.ReportViewer.ProcessingObjectModel, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

i try run on my machine its all work fine, but when i complier and run it on Window server 2008 get this error.

I read http://forums.asp.net/p/1513402/3613239.aspx I install the ReportViewer.exe but still cannot find the Microsoft.ReportViewer.ProcessingObjectModel.dll, however I got find it Microsoft.ReportViewer.ProcessingObjectModel in C:\Windows\assembly and is not a dll file. any suggestion?



there was an error processing the request


 Hi, I implement a project which has a ajax plus web service. It works out on IDE VS 2008 Express.

Now I host it on a free space, get an error "there was an error processing the request".

The error type is empty.

Any experience is thankful.

Nintex Workflow Error: No workflows are waiting for a BizTalk message [...] No processing has been d



I created a Workflow with Nintex Workflow 2007 (on SharePoint 2007) to send/receive data to BizTalk 2009. It worked fine already. But now I get the following error mesage in the EventViewer:

Nintex Workflow; Build: 11000 (http://ls457/_layouts/nintexworkflow/BiztalkHandler.ashx)
No workflows are waiting for a BizTalk message with message Id of 'GeneralAccessRequest_2010-08-23T15_00_04_44961212B370C554EDFAC41C1201ED6CEFB' on teamsite http://ls457/sites/testapp. No processing has been done.

What could that mean? Any ideas? I definitely changed nothing on the orchestration or BizTalk administration. The BizTalk action sends the data correctly to it's destination (database), but it seems that nintex doesn't receive any return data. I don't think it's a BizTalk problem, because in the BizTalk Message Tracking Database the Message is listet, so it has been sent correctly by BizTalk. But the handler probably has problems to find/receive this message.

Kind regards,


Error in Crystal report while running at webserver



I need ur help its urgent i got a problem while running crystal report at web server.On local host its work fine bt on web server it gives error in web config file(assembly error).Please reslove it.

I m sending u the snapshot of error.

Code of server side script:-

 protected void Page_Load(object sender, EventArgs e)
        if (!IsPostBack)
            SqlConnection con = new SqlConnection(Session["MyDb"].ToString());

Error While Loading Crystal Report


 Dear Friend


WHen ever i try to load in built  crystal report  which comes along with  Visual Studio

error is arising for me.


The  error is as follows :


Retrieving the COM class factory for component with CLSID {11BD5260-15B6-412D-80DB-12BB60B8FE50} failed due to the following error: 80070005.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {11BD5260-15B6-412D-80DB-12BB60B8FE50} failed due to the following error: 80070005.

ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenti

Report Viewer Control Error

Hi All, I am adding a report datasource dynamically to report view web server control and getting the following eroor when i open the page. The DataSourceID of the ReportDataSource 'DataSet1_employees' of the ReportViewer 'ReportViewer1' must be the ID of a control of type IDataSource. A control with ID 'DataSet1_employees' could not be found.     Please help me where i am going wrong. The code is given below: protected void Page_Load(object sender, EventArgs e)    {        ReportViewer1.ProcessingMode = ProcessingMode.Local;        ReportViewer1.LocalReport.ReportPath = "Report2.rdlc";         ReportDataSource rdS = new ReportDataSource("Employees", GetData());        rdS.DataSourceId = "DataSet1_employees";        //this..Add(rdS);                ReportViewer1.LocalReport.DataSources.Add(rdS);        ReportViewer1.LocalReport.DataSources["Employees"].DataSourceId = "DataSet1_employees";        ReportViewer1.LocalReport.DataSources["Employees"]

ssrs 2008 R2 - report parameter with no default set throws java script error

We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2.  As soon as I put a 'default' value on the report param, everything is fine.  However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.
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