Stored Procedure call: The expression contains object 'myobject' that is not defined in the current context

[Kirivarnan]

Hi, 

I'm very new to telerik reporting. Please check my issue below. 

I have created a telerik report using designer. This report calls stored procedure to retrieve the data and binds to chart. 

I'm getting following error message when I generate the report via report viewer. 

      "The expression contains object 'dtScan' that is not defined in the current context". 

I have already added all required report parameters (input parameters). Actually this 'dtScan' is not an input parameter. It is a one of the data table field and using inside my stored procedure. I'm sure that there is no issue on my stored procedure. It is working perfectly when I design the report (means that when I set stored procedure to report via design wizard).

As I mentioned, I'm getting this error message when I generate report via report viewer and as well as preview window (please see the attached images).

 Please looking forward your help to solve this issue. 

 Thanks!

[Kirivarnan]

Finally, I managed to understand the problem. It because of 'temp' table. 

Please refer ​this link http://www.telerik.com/forums/temporary-table-in-stored-proc​

Hope this helps others!

[Kirivarnan]

Sorry, It is not working. still I couldn't able to fix this problem....

[Stef]

Hi Kirivarnan,

The error indicates you are using a field dtScan, which is not available in the Graph item's DataSource fields.


If the stored procedure uses temporary tables, you will need to add a setting allowing the SqlDataSource to retrieve the data schema - How to configure Stored Procedure with Temporary Tables for use with SqlDataSource component.

This will allow available fields to be loaded in the Data Explorer and used in expressions. Note that a field is available only in the scope defined by the item bound to the corresponding data source component - Expression scope. By suing the ReportItem.DataObject in expression you can get fields of parent data scope - How to use the ReportItem.DataObject property in expressions.


I hope this information is helpful.

Regards,
Stef
Telerik