Configuring Report Parameters in Telerik Reporting
Environment
| Product | Author |
|---|---|
| Standalone Report Designer | Desislava Yordanova |
Description
While using the Standalone Report Designer, I encountered an error during the preview: "The expression contains object 'InspectionId' that is not defined in the current context."
I have configured a parameter, and my select statement includes this parameter. Although executing the query with a design time value returns one record from the data view, the preview fails with the mentioned error. This KB article also answers the following questions:
- How do I link SQL data source parameters to report parameters in Telerik Reporting?
- What steps should I follow to ensure my report parameters are recognized during the preview?
- Why is my report parameter not found in the current context during the preview?
Solution
To resolve the issue where a report parameter is not recognized in the report preview, ensure that the report parameter is correctly defined in the report's parameters collection and linked to the SqlDataSource component.
-
Verify that the report parameter is added to the report parameters collection. Refer to the Report Parameters Overview for guidance on defining report parameters.
Report Parameter
For detailed steps on adding and configuring report parameters, consult the Approaches for Adding Report Parameters guide.
-
Ensure that each SqlDataSource parameter is linked to an expression, such as a report parameter value, in the report definition. SqlDataSource parameters cannot directly receive values from the ReportSource.Parameters collection. Review the Using Parameters with the SqlDataSource Component for more details.
SqlDataSourceParameter
By following these steps, you ensure that your report parameters are correctly recognized during the preview, preventing errors related to undefined objects in the current context.