Finding the parameters to send to a report.

[KawaUser]

I have created a report and it runs just fine if I manually put the parameter values in the query builder. I am using a SQL Data source that looks like this:

SELECT     REJECT_REPORT.VENDOR, COUNT(DISTINCT REJECT_REPORT.REJECT_ID) AS QTY_RRs, RR_CATEGORY.CATEGORY, @startDate AS STARTDATE,
                      @endDate AS ENDDATE
FROM         REJECT_REPORT LEFT OUTER JOIN
                      RR_CATEGORY ON REJECT_REPORT.CATEGORY = RR_CATEGORY.CATEGORY_ID
WHERE     (REJECT_REPORT.OCCURENCE_DATE BETWEEN @startDate AND @endDate)
GROUP BY REJECT_REPORT.VENDOR, RR_CATEGORY.CATEGORY, REJECT_REPORT.CATEGORY

 
I have tried all sorts of things trying to input the parameter. Including:

ReportViewer1.Report.ReportParameters("@endDate").Value =

frmDateInput.dtpEnd.Value.ToShortDateString

Dim report As New CategoryReport

        report.ReportParameters.Add("@startDate", Telerik.Reporting.ReportParameterType.DateTime, "9/1/2010")

        report.ReportParameters.Add("@endDate", Telerik.Reporting.ReportParameterType.DateTime, "9/30/2010")

        ReportViewer1.Report = report

Dim report As New CategoryReport

        report.ReportParameters.Add("@startDate", Telerik.Reporting.ReportParameterType.DateTime, "9/1/2010")

        report.ReportParameters.Add("@endDate", Telerik.Reporting.ReportParameterType.DateTime, "9/30/2010")

        ReportViewer1.Report = report

Dim report As New CategoryReport

        report.ReportParameters.Add("@startDate", Telerik.Reporting.ReportParameterType.DateTime, "9/1/2010")

        report.ReportParameters.Add("@endDate", Telerik.Reporting.ReportParameterType.DateTime, "9/30/2010")

        ReportViewer1.Rep

Dim report As New CategoryReport

        report.ReportParameters.Add("@startDate", Telerik.Reporting.ReportParameterType.DateTime, "9/1/2010")
        report.ReportParameters.Add("@endDate", Telerik.Reporting.ReportParameterType.DateTime, "9/30/2010")

        ReportViewer1.Report = report

Am I doing this right?

I just want to send 2 date values to my report.

Thanks,
Charles Hawk

[KawaUser]

I figured this out. No need for reply thank you.

[des white]

Hi Kawa,

How did you resolve this.

I have the same issue?

Many Thanks, Des