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

   jaswinder1974, Dec 12, 2005

   #2
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

   Madhivanan, Jan 5, 2006

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in