Date: 04/05/07 (SQL Server)    Keywords: asp, sql, web

I'm building a web application that will use Reporting Services as a reporting tool.

The question I have is this: I have a report that shows projects by various categories (which are parameters to the report). How do I set the Reporting Services parameters without creating my own drop-lists on the aspx page? In the Report Viewer control, I can enter the option "ReportViewer1.ShowParameterPrompts = true;" but I then run the code and change a parameter, it just posts back and doesn't change the parameter's value (like it does from the report server). Am I missing something, or will I have to code drop-boxes for the parameters?

Thanks for any help you can give.

Cross-posted to sqlserver and csharp

Source: http://community.livejournal.com/sqlserver/57483.html