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

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

1 Answer 85 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Charlie
Top achievements
Rank 1
Charlie asked on 15 Nov 2018, 04:23 PM
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

1 Answer, 1 is accepted

Sort by
0
Silviya
Telerik team
answered on 20 Nov 2018, 09:32 AM
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
Tags
Report Designer (standalone)
Asked by
Charlie
Top achievements
Rank 1
Answers by
Silviya
Telerik team
Share this question
or