0

Dear All,

How can i get Crystal report between two dates from SQL SERVER Database.

We will enter the dates from One column.

Any help will be apriciated.

2
Contributors
4
Replies
5
Views
7 Years
Discussion Span
Last Post by bhagawatshinde
0
Private Sub btngo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btngo.Click
        'here crt_datewise is the name of crystal report
        'rpt_datewisePolicy_display1 is the crystal report document name        
          crt_datewise.Visible = True
            crt_datewise.ReportSource = rpt_datewisePolicy_display1
            crt_datewise.SelectionFormula = "{policy_info.comin_date} in DateTime (" & Format(dtpfrom.Value, "yyyy,MM,dd") & ") to DateTime (" & Format(dtpto.Value, "yyyy,MM,dd") & ")"
            crt_datewise.RefreshReport()
   End Sub

its working

Edited by Nick Evan: Fixed formatting

0

It is not working on the click event of button

"Variable Inst2.Visible = True is nor memeber of Payment System"

Also i am unable to understand the folowing line of code.

rpt_datewisePolicy_display1
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.