anuraja
asked on
Visual Basic coding for Crystal report
Dear Sir,
I am now working with one Visual Basic Project. In that I have to filter
the records using the date field. If I am use it in directly it can filter the required data. But I how can I filter from the coding. I am using this
ie. Crystalreport1.Selection formula = "{dat.fdate} < '29/03/2003'"
But it can not filter it. Is there any coding technique available
Please send me the above information to my id navadhak@yahoo.com
Thank you
Regards, Raja
When you pass a data source to the report at runtime pass recordset with a SQL statement where date < 29/03/2003.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
OOPS!
Above should read:
.SelectionFormula = "{dat.FDate} = Date(" & Year(txtFrom) & "," & Month(txtFrom) & _
"," & Day(txtFrom) & ")"
Above should read:
.SelectionFormula = "{dat.FDate} = Date(" & Year(txtFrom) & "," & Month(txtFrom) & _
"," & Day(txtFrom) & ")"
For the RDC use
.RecordSelectionFormula = "{dat.FDate} = Date(" & Year(txtFrom) & "," & Month(txtFrom) & _
"," & Day(txtFrom)
mlmcc
.RecordSelectionFormula = "{dat.FDate} = Date(" & Year(txtFrom) & "," & Month(txtFrom) & _
"," & Day(txtFrom)
mlmcc
ASKER
This website providing a good clarification