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

No Design wizard when sqldatasource not showing fields being returned

1 Answer 38 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Joshua Gates
Top achievements
Rank 1
Joshua Gates asked on 26 Oct 2010, 05:05 PM
I have a stored procedure that builds a temp table within itself and returns its results. however when i add the sqldatasource to a report via the wizard i get results when i execute it. but no data fields show up. and it does not allow me to continue the wizard as far as designing the report with theme etc. it stops at the selected datasource.
any ideas on how i can rememdy this?

Joshua

1 Answer, 1 is accepted

Sort by
0
Joshua Gates
Top achievements
Rank 1
answered on 26 Oct 2010, 05:19 PM
ok found solution.
it seems to be a microsoft issue more than telerik.

Adding the following line right under the AS in my stored procedure allowed the report to see the data fields etc and continue with the report design wizard

IF

 

1=0 BEGIN

 

 

SET FMTONLY OFF

 

END

Tags
General Discussions
Asked by
Joshua Gates
Top achievements
Rank 1
Answers by
Joshua Gates
Top achievements
Rank 1
Share this question
or