November 9th, 2013, 02:10 AM
Crystal Report XI R2 Problem
I have designed the Report manually & in a Command button on a form
I have written
The Report returns all Records Beyond the dates I entered !!!
Dim sStartDate As Date
Dim sEndDate As Date
Dim sSQL As String
sStartDate = Format(DTPicker1.Value, "dd/mm/yyyy")
sEndDate = Format(DTPicker2.Value, "dd/mm/yyyy")
sSQL = "select * from Sales where SellDate BETWEEN " & sStartDate & " and " & sEndDate
DataEnvironment1.Partsale sStartDate, sEndDate
I am using CrystalReports XI R2
Is there anyone who can help me with this?please...
Last edited by dsrahul; November 11th, 2013 at 04:27 AM.
Reason: No helps !!!
Click Here to Expand Forum to Full Width
This is a CodeGuru survey question.