Table Wizard Issues

[Aarsh]

Hi friends,

I am having an issue where if I configure the datasource for my report, it wokrs fine, but if I try to run the table wizard and to select that table source it throws an err as below:

<Err dailog box being prompted when trying to select the datasource form the Insert Table Wizard.png>

However,

1. At the time of configuring the database, I passed some 'desgin time parameter values' to the parameters and executed with the telerik datasource wizard, as a result 62 rows were returned as expected.
2. The stored procedure seemed to be working flawless in the SQL MS 2008R2
3. Other reporting tool works fine with the same, but tekerik does not

Here is an err shown in the telerik:

Below are some of the recent activities being observed in the SQL profiler:

------------------------------------------------------------------------------------------------

exec [<DBNAME>].[sys].[sp_procedure_params_100_managed] @procedure_name=N'<STORED_PROCEDURE_NAME',@procedure_schema=N'<SCHEMA_NAME>'

exec <SCHEMA>.<STORED_PROCEDURE_NAME> @<PARAMETER_VALUE_LIST> // this executed fine in SQL MS 2008R2 and I got 62 rows in the Telerik DataSource confguration manager, too. The parameter values were all exactly same as I had passed and were seemed to follow the constraints.

exec sp_reset_connection

-- network protocol: TCP/IP
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed

--RPC:Completed
exec [<DATABASE>].[sys].[sp_procedure_params_100_managed] @procedure_name=N'<SP_NAME>',@procedure_schema=N'<SCHEMA_NAME>'

[Steve]

Hi Aarsh,

Try the same steps without using Telerik Reporting. In Visual Studio, use Server Explorer to create Data Connection to your database server. Expand this Data Connection, navigate to Stored Procedures, select yours and execute it.

Kind regards,
Steve
the Telerik team