rsProcessingError - Reporting Services Error
Applies To: SQL Server 2016
|Product Name||SQL Server|
|Message Text||Errors have occurred in report processing.|
One or more errors were encountered while publishing, processing, previewing locally, viewing from the report server, or creating a subscription for a report. This error message indicates at least one error was detected.
Possible causes include:
A processing error occurred on the report server.
A processing error occurred during local report processing when previewing a report.
A group expression evaluated to an incorrect data type.
A filter definition specified two expressions that evaluated to data types that could not be compared.
An expression referenced a non-existing field in the Fields collection.
An expression included an aggregate function call with an invalid or conflicting scope.
An expression referenced a non-existing parameter in the Report Parameters collection.
A custom assembly or a Reporting Services assembly that was incorrectly deployed failed to load.
A parameter that has the Nullable property set to False has detected a null value in the parameter.
An expression for the Hidden property of a data region contains an error: Object reference not set to an instance of an object.
An expression included an invalid function call or syntax error.
Do one or more of the following actions:
If you are viewing the report from the report server or if you are viewing the report as a subscription, look at the entire text of the error message. Additional information is provided in the expanded text.
If you are authoring a report in Report Designer and see this error when you preview or publish the report, additional information is provided in the Error List window.
If you are authoring a report in Report Designer Preview, look at the entire text of the error message. Additional information is provided in the expanded text.
If you are viewing a report on the report server, and if you are running as local administrator on the report server, you can view the call stack if you right-click the page and select View Source. Additional information is provided in the call stack.
If you are running as local administrator on the report server, search the log file for
ReportProcessingException. Log entries contain more information. The report server log file is typically located at <drive>:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\LogFiles\ReportServerService__datetimestamp.log. For more information, see Reporting Services Log Files and Sources.
Check the spelling in expressions. Built-in globals, parameters, and field names are case-sensitive. In the expression causing the error, check that the name actually exists in the report and that it is spelled correctly. For more information, see Built-in Collections in Expressions (Report Builder and SSRS).
A multivalue parameter cannot be Null. For more information, see Report Parameters (Report Builder and Report Designer).
A report with subreports must be processed by the same version of the Reporting Services report processor. When upgrading reports to the current version of the report definition schema, the main report and the subreports may or may not be updated at the same time. If the version is not compatible between a report and its subreports, the following message is displayed: "Subreport could not be processed."
You must change either the main report or the subreports so that all the reports can be processed by the same version of the report processor. For information about why a report fails to upgrade, see Upgrade Reports.
You can use SQL functions in query text on a relational database. You cannot use Visual Basic functions in query text.
In Reporting Services, expressions can use Visual Basic functions, System.Math or System.String functions, fully qualified .NET Framework functions, or custom functions that you provide in custom code or a custom assembly. You cannot use SQL functions in an expression.
Verify that the function calls made in the query and in the expressions are valid.
In a filter equation, the filter expression that defines what to filter on and the filter value must be the same data type in order to be compared. If you see one of the following errors, modify the field expression or the filter value so that the data types match:
The processing of <report item type> for the <report item name> cannot be performed. Cannot compare data of types <type> and <type>. Please check the data type returned by the <report item name>.
Failed to evaluate the <property name>.
Failed to evaluate the <property name>. It references a dataset field which has an error: <error string>.
For more information, see Filter, Group, and Sort Data (Report Builder and SSRS).
When you include aggregate function calls to an expression in a Tablix cell, the report processor evaluates the expression in the scope of the innermost groups to which the cell belongs.
You can also pass the name of a specific scope to an aggregate function. Scope can refer to the name of a dataset, a data region, or the name of a scope higher on the data hierarchy. This applies to the following messages:
The <report item type> '<report item name>' has an invalid scope “<scope name>”. The scope must be the current scope, or contained within the current scope.
The <property name> expression for the <report item type> '<report item name>' has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset.
For aggregate functions that calculate running totals (Previous, RunningValue, or RowNumber), you can specify a scope parameter that is either a row group name or a column group name, but not both. This applies to the following error message:
- Previous, RunningValue or RowNumber aggregate functions used in the data cells of the <report item type> '<report item name>' refer to grouping scopes in both the columns and rows of the <report item type>. The scope parameters of all Previous, RunningValue and RowNumber aggregate functions within a <report item type> can refer to row groupings or data column groupings, but not both.
Do not use a default scope for a text box added to the report design surface when the report has more than one dataset. Use an expression that includes the name of the dataset as the scope, and an aggregate function. For example,
Expressions (Report Builder and SSRS)
Aggregate Functions Reference (Report Builder and SSRS)
Expression Examples (Report Builder and SSRS)
Report Datasets (SSRS)
Commonly Used Filters (Report Builder and SSRS)
Dataset Fields Collection (Report Builder and SSRS)
Custom Code and Assembly References in Expressions in Report Designer (SSRS)
Parameters Collection References (Report Builder and SSRS)