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:
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.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)
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!


Reply With Quote