No Data Source with Project data source

[David Gregory]

Hello,

I tried to define a project SqlDataSource using a stored procedure. I defined it with a default value as required in order to see it in the Data Explorer. However, when I go to select the table item I applied the data source to, the Data Explorer shows No Data Source.

I used SQL Profiler to see what was happening. When I click on the data source at the bottom of the designer it executes the stored procedure with all parameters as null, thus returning no result set.

I opened the SqlDataSource component I created and it does have the parameter defined with a default value.

Oh, and if you select Preview it returns data.

Any help would be appreciated.

[David Gregory]

A few more things to pass along....

I created a report SqlDataSource and I'm still having the same problem. If I click either on the data source item or table item in the designer No Data Source is still displayed. The difference this time is that it is passing the stored procedure parameter value and is returning data.

Also, if I open another project (which I downloaded from Telerik) I still have the same problem.

And finally, if I create a brand new report using the Report Wizard, the wizard does not continue pass the data source creation section. My guess is that this relates to the problem with the data source.

It should also be noted that I reinstalled VS 2010 last night and that didn't solve anything.

[David Gregory]

I identified the problem. When report designer queries for the metadata from SQL Server it uses SET FMTONLY ON. The stored procedure contains dynamic SQL. There seems to be a bug with how SQL Server handles this specific case.

I'll figure out a work around.

Thanks.

[Steve]

Hi David,

You can see the workaround in the following forum post.

All the best,
Steve
the Telerik team