SQL Server Performance Forum – Threads Archive

Runtime problem with RS

HI I am new to RS. I want to pass a select statement to RS from ASP page at runtime. I am working on search page in ASP. I want to show a report, depands on search creteria. In the design time I don’t know what are the columns are going to show.

---

1. Create a parameter (ex myQuery) with default value that would return all fixed columns and dynamic columns named something like Col1, Col2 … (Use data-field AS Col1) 2. In the data tab type the expression = Parameter!myQuery. 3. You should now be able to all the fields returned by the default parameter value. 4. The rest should be easy from ASP.

---

]]>