>My problem is I don't know where or how to add a parameter for what I need to do. The only parameters that were in there before were for dates and whatnot, the SP was used for reporting purposes so those were entered in the report. I don't know how to add a parameter that will only display results based on user input on the HTML page.
I think you need to divide the problem.
1. Let's concentrate on creating a working select statement that will return desired results based on your parameter.
Once you done that, you can put this select statement into stored procedure (it can be a new one, not the same used for RS)
2. If you have SP working correctly and returning data, then the only remaining problem is to call it from the client app with the appropriate parameters.
If it's not broken, fix it until it is.
My Blog