Reporting Services 2005 Report Parameters - Windows Application
SQL Server 2005/Reporting Services 2005
I have created a Windows Forms application and it includes several reports that I am rendering in reporting services utilizing the reportviewer control. My problems is that the parameter prompts are not displayed when the reports render. When I run the reports directly from reporting manager the parameter prompts are displayed.
I have set Me.ReportViewer1.ShowParameterPrompts = True. They still don't display.
Through my research all I've found is this:
Code:
Dim params(2) As Microsoft.Reporting.WinForms.ReportParameter
params(0) = New Microsoft.Reporting.WinForms.ReportParameter("ReportMonth", 6)
params(1) = New Microsoft.Reporting.WinForms.ReportParameter("ReportYear", 2007)
params(2) = New Microsoft.Reporting.WinForms.ReportParameter("CustomerID", "125")
ReportViewer1.LocalReport.SetParameters(params)
This makes no sense to me. Why would I need a parameter if I'm going to hard code the parameter values? I would have just hardcoded the values in the query itself.
First: How do I get the report parameter boxes to show?
Second: How can I pass in the parameters supplied by the user at run time?
Thanks in advance!