ASP.NET & SQL Reporting Querystring Parameters
Posted on 2007-08-08
I am working on my first SQL Report and ahve the report designed, and I have my SQL statement with no dynamic parameters done. Now I want to integrate it into a web site and have the website pass a querystring with the value for a single parameter for the SQL statement to use. The condition I want to add is District_Name = '<passed value>'. I have gone through several walkthroughs but have not been able to get it to work. So, what are the steps for me to add the condition to my where clause in the report so that it reads the value from the query string, and what should that part of the querystring look like?