Missing values in report definition
The following error is also not uncommon with SQL Reporting Services:
An error occurred during local report processing.
The definition of the report '/ABC' is invalid.
The report definition is not valid. Details: The element 'QueryParameter' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition' has incomplete content.
List of possible elements expected: 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Value##other:*'.
The last time this happened after I threw away some ReportParameters, which were linked to. The trick to solve this one is as follows:
- Do right-click; view code on the rdl file.
- Look for QueryParameter elements that have no value element contained.
- Enter a value element corresponding to the pattern below
<QueryParameter Name="MyParam">
<Value>=Parameters!MyParam.Value</Value>
</QueryParameter>
After this, close the rdl file, and open it again, so that de designer will parse the file again, an so, no longer give the error
After this, close the rdl file, and open it again, so that de designer will parse the file again, an so, no longer give the error
After this, close the rdl file, and open it again, so that de designer will parse the file again, an so, no longer give the error