Creating a Chart in a telerik report using a Stored Procedure as the datasource

[Tony]

Application Type: ASP.NET

Telerik version: Telerik Report Q1 2014

Dev environment:  Visual Studio 2013

I am trying to create a chart using a stored proc as the data source. I can create a table using the data without a problem however when I create a chart it throws an error referencing a temp table I use in my SP. "An error occured while processing Chart 'Chart1' Invalid Object name '#Temp_StatsTable' "

Any input or direction would be much appreciated!

Thank you

[Katia]

Hi Tony,

When the stored procedure uses temporary tables the data provider fails to retrieve the schema.

Thus, test applying the settings for retrieving the data schema listed in the How to configure Stored Procedure with Temporary Tables for use with SqlDataSource component KB article.

In case, the issue persists please open a support ticket and attach a problematic report with test data so we can test it locally.


Regards,
Katia
Telerik