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.

Recommended Answers

All 4 Replies

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

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

No body has any idea please help

'here crt_datewise is the name of crystal report
'rpt_datewisePolicy_display1 is the crystal report document name

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.