Table Wizard Issues

2 posts, 0 answers
  1. Aarsh
    Aarsh avatar
    192 posts
    Member since:
    Jun 2012

    Posted 16 Oct 2012 Link to this post

    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>



    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

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

  2. Steve
    Steve avatar
    10941 posts

    Posted 18 Oct 2012 Link to this post

    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,
    the Telerik team

    HAPPY WITH TELERIK REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

Back to Top