.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 processing report with embedded subreport while leveraging interactive sorting in main report.

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :Sql Server

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()


View Complete Post

More Related Resource Links

Linked Report Subreport- Error: Subreport could not be shown on SSRS 2008r2

I've got 2 folders: /Finance /Japan In the Finance folder I have a Sales report that has 3 subreports, and a salesregion parameter. I created a linked report in /Japan to /Finance/Sales, hide the salesregion parameter, and set the default to Japan, so they can only see their region's sales data. But when a Japan user runs the Sales report, they get Error: Subreport could not be shown because they do not have access to the /Finance folder. Any ideas?

Formula on Main Report Using a Field from Subreport

Hi, I try to use a value coming from a cell which contain a subreport. I need to create a formula using this value. So I tried : =Code.CalcPct(CountDistinct(Fields!s_contactsvisited.Value), Globals!CALL_SubReport) But I've an error: [rsRuntimeErrorInExpression] The Value expression for the textbox textbox9 contains an error: Specified argument was out of the range of valid values. Thanks for you help,      

Error while Report Processing :

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 

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

SSRS 2008 - Subreport passing a value back to the main (master) report



Looking for a way to pass a calcuated value or Sum from a Subreport back to the Main Report.   Is there anyway to do this.  In past posts, with the most recent being 2008, it is said that this feature was not available or included in SSRS.

Using SSRS 2008.



Using Report Parameters to pass data from a subreport to the main report?

I am creating a report where I need to use a subreport to pass data to the main report from a different dataset than the main report is using, I need to have the data from the subreport grouped on a field from the main report which is using a different dataset. I think I need to use a Report Parameter to do this but am struggling with figuring out how to set the parameter correctly. any useful advise would be appericated.
Stacey P. Shoemaker

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

Stop Sorting Cross Tab Report Header


Dear, I want to stop sorting in cross tab report header. And also want to sort in specific order. How can i do that? Please help me. Its urgent


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?



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());
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