Entity datasource not showing dataset

3 posts, 0 answers
  1. Jack
    Jack avatar
    6 posts
    Member since:
    Jan 2017

    Posted 18 Jan 2017 Link to this post

    Using, VS Professional 2015, Win 10, SQL Server 2016.  I have built several SQL stored procedures to fetch data, integrated them into Entity framework and have successfully used them for both main report datasources and as lists of values for report parameters, accessing them as Entity DataSources.

    However, one stored procedure does not work right.  After adding it to a new Entity datasource for a report parameter, the column names in its output dataset are not displaying, just an unusable thing named 'item'.

    When the wizard gets to Select a Context Member, I pick this:

    Method: RptUtlTimeZone(Nullable<Int32> systemTimeZoneId, Nullable<Boolean> returnResultSet, String& zoneMsName) : List<RptUtlTimeZoneReturnModel>
    Type: Myriad.Pc.Data.SqlServer.PointCentricContext
    Assembly: Myriad.Pc.Data.SqlServer, Version=, Culture=neutral, PublicKeyToken=null

    Looks similar to all the other stored procedures that work correctly.  Note that it does have the output data set definition List<RptUtlTimeZoneReturnModel>

    The Wizard completes, I go to Data Explorer and all I see is "item".

    Here is part of the file from Visual Studio which describes the output data set - RptUtlTimeZoneReturnModel.cs

        public partial class RptUtlTimeZoneReturnModel
            public System.Int32? SystemTimeZoneId { get; set; }
            public System.String ZoneMSName { get; set; }

    and this looks fine.

    But why does Data Explorer not display the proper columns in the output data set?  Thanks.


  2. Jack
    Jack avatar
    6 posts
    Member since:
    Jan 2017

    Posted 19 Jan 2017 Link to this post

    After further investigation and collaboration, the issue is that Report Designer gets confused importing the dataset definition.  This seems to happen if the stored procedure has an argument marked as "OUTPUT".  Perhaps this could be addressed.
  3. Stef
    Stef avatar
    3610 posts

    Posted 20 Jan 2017 Link to this post

    Hello Jack,

    Out parameters are not supported. If you modify the method to not expect an out parameter it should work or you can add more methods - Retrieving data from an Entity Data Model with the EntityDataSource component.

    Telerik by Progress
    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