Member Avatar for Naveed_786

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
  • 103 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by bhagawatshinde
Member Avatar for bhagawatshinde 
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 because: Fixed formatting
Member Avatar for Naveed_786

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
Member Avatar for Naveed_786

No body has any idea please help

Member Avatar for bhagawatshinde

'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.