Send Whole SQL string to the Report (Nt jst prms) | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

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


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
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
]]>