SQL Server sp_executesql stored procedure (no columns appearing in report designer)

2 posts, 0 answers
  1. Charlie
    Charlie avatar
    1 posts
    Member since:
    Mar 2012

    Posted 15 Nov 2018 Link to this post

    Am new to Telerik reporting. Have tried creating a report where data source accesses SQL Server stored procedure that uses sp_executesql command. There are no temporary tables in this sql. The resulting data source does not show any of the columns from the stored procedure. Is there a work-around for dealing with this? Thanks
  2. Silviya
    Admin
    Silviya avatar
    399 posts

    Posted 20 Nov 2018 Link to this post

    Hello Charlie,

    We have performed tests to see how SqlDataSource retrieves the data in the context of both Visual Studio Designer and Standalone Report Designer, however, we're not able to reproduce the issue. 

    Our guess is that the fields that are missing are of the type that cannot be supported by the SqlDataSource, e.g. custom types. Please, let us know what are the types of the fields that are missing from the Data Explorer.
    Also, it would be highly appreciated if you open new support ticket and send us the following information:
    - a step-by-step instructions on how to reproduce the issue;
    - if possible, send a mock up of the data, so we can plug it in our testing environment.

    Regards,
    Silviya
    Progress 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