This is a migrated thread and some comments may be shown as answers.

Entity datasource not showing dataset

2 Answers 156 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Jack
Top achievements
Rank 1
Jack asked on 18 Jan 2017, 08:55 PM

Using 10.2.16.1025, 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=1.0.0.0, 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 Answers, 1 is accepted

Sort by
0
Jack
Top achievements
Rank 1
answered on 20 Jan 2017, 04:09 AM
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.
0
Stef
Telerik team
answered on 20 Jan 2017, 10:29 AM
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.
 

Regards,
Stef
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
Tags
Report Designer (standalone)
Asked by
Jack
Top achievements
Rank 1
Answers by
Jack
Top achievements
Rank 1
Stef
Telerik team
Share this question
or