ReportParameters in Date Type

[Meera]

Hi !
How to pass Date type parameter to a Report viewer?? as Report parameter.
if tried, im getting the following error..

Value of type 'Date' cannot be converted to 'Microsoft.Reporting.WinForms.ReportParameter'

Kindly share ur knowledge to arrive at solution.

Thanks,
Meera.

 

[Meera]

Hi all !

Please help me ..urgent...In Visual Studio VB 2005

I am holding a VB.Net form with a Report viewer dropped in it along with 2 TextBox es and a Button.

Now i have linked a report tht works well in the query builder with FromDate and ToDate parameter.

In the VB.Net Code when i tried to execute the form im always getting a error like either

'Type 'FromDate' string cannot be converted to 'Date' type ' or



Value of type 'Date' cannot be converted to 'Microsoft.Reporting.WinForms.ReportParameter'.

please assist me how to achieve passing Date type parameter as REportParameter in the ReportViewer.

Code is as follows:

-------------------------------------

Dim F_Date As Date = TextBox1.ToString

Dim T_Date As Date = TextBox2.ToString

Dim FDate As New ReportParameter(F_Date)

 Dim TDate As New ReportParameter(T_Date)

Dim rp() As ReportParameter = {FDate, TDate}

 
'TODO: This line of code loads data into the 'Sales.DataTable1' table. You can move, or remove it, as needed.

        Me.DataTable1TableAdapter.Fill(Me.Sales.DataTable1, "F_Date", "T_Date")

        Me.ReportViewer1.LocalReport.SetParameters(rp)

        Me.ReportViewer1.RefreshReport()
 

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Try

            Me.DataTable1TableAdapter.Fill(Me.Sales.DataTable1, TextBox1.ToString, TextBox2.ToString)

            Me.ReportViewer1.RefreshReport()

        Catch ex As Exception

            System.Windows.Forms.MessageBox.Show(ex.Message)

        End Try

    End Sub

----------------------------------------



PLease any one help me....

 

[Meera]

Superb Help... Thanks a LOT !!!