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

2 posts, 0 answers
  1. Tony
    Tony avatar
    1 posts
    Member since:
    Nov 2014

    Posted 28 Apr 2016 Link to this post

    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

  2. Katia
    Katia avatar
    599 posts

    Posted 03 May 2016 Link to this post

    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.

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top