SQL Server Performance

Send Whole SQL string to the Report (Nt jst prms)

Discussion in 'SQL Server Reporting Services' started by jaswinder1974, Dec 12, 2005.

  1. jaswinder1974 New Member


    Is it possible to send the complete SQL string from my ASP.NET form to the ReportViewer component? Just passing the parameters does not solve my purpose. I need to send the whole SQL string to the report.


    Jaswinder Singh
    A K ITech Limited
    London, UK
  2. Madhivanan Moderator

    You can create stored Procedure that accepts your query as Input parameter. Then run it by
    EXEC(@sqlStatement). Design the report using that Stored Procedure

    Madhivanan

    Failing to plan is Planning to fail

Share This Page