Member Avatar for jithusdani

Hi folks..

I want to display the crystal report according to the date that user select...If User changes the date means it should change the report according to that...
In my applocation two date picker and one button is ter ,if user select from date and to date means it should display the report between that date..

plz help me asps...

  • 2 Contributors
  • 1 Reply
  • 82 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Jx_Man
Member Avatar for Jx_Man

try This :

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

        CrystalReportViewer1.SelectionFormula = "Date({TableName.FieldName}) >= #" & dtStartDate.Value & "# And Date({TableName.FieldName}) <= #" & dtEndDate.Value & "#"
        CrystalReportViewer1.RefreshReport()

End Sub
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.