Joshua Gates
Top achievements
Rank 1
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
any ideas on how i can rememdy this?
Joshua
1 Answer, 1 is accepted
0
Joshua Gates
Top achievements
Rank 1
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
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