Two SqlDataSource with same stored procedure causes issues in Telerik Report

4 posts, 0 answers
  1. Devesh
    Devesh avatar
    5 posts
    Member since:
    May 2016

    Posted 24 May Link to this post

    Hi,

    I am observing an error when there is a report file having one chart and a tabular grid. Both of these controls are using different SqlDataSource but they call common stored procedure with different parameters.When opened in Standalone Designer application, both of the datasources show same Result(attached snapshot: Sqldatasource1, Sqldatasource2). However, in reality if different values are passed in a stored procedure, it produces different result.

    Any help will be appreciated.

     

    Thanks

    Devesh

     

  2. Devesh
    Devesh avatar
    5 posts
    Member since:
    May 2016

    Posted 24 May in reply to Devesh Link to this post

    I am using Reporting R2 2016
  3. DevCraft banner
  4. Devesh
    Devesh avatar
    5 posts
    Member since:
    May 2016

    Posted 24 May in reply to Devesh Link to this post

    Hi,

    I am using Telerik Reporting R2 2016

  5. Katia
    Admin
    Katia avatar
    307 posts

    Posted 27 May Link to this post

    Hi Devesh,

    The error in the attached screenshot indicates that some properties of Graph item cannot be evaluated as the expression contains undefined object.

    Check the settings of Graph item and make sure the expressions use only the data fields that exist in Graph's data source. More details can be found in Using Expressions help article.

    If you want to access the data fields from a different data scope you can use data functions.

    Also verify that the stored procedure returns properly the same data schema each time it is called.


    If the above information does not help, please attach a problematic report in a support ticket so we can check the settings.

    Regards,
    Katia
    Telerik
    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