Crystal Report+VB Data Accessing Problem

[basuprasen]

Hello guys,
I am using VB6 and crystal report version 8(OLDER ONE). I am able to show crsytal report from VB form. But the report is working as a static REPORT ! There is a field in my form called enddate(A DTPicker control). I want to display records from crystal report for those where enddate-date()<=20.
I have passed this from SQLQuery. But it is not working. Please Help.

[Phil Weber]

If you don't get an answer here, you might try Crystal's tech support site: http://support.businessobjects.com/

[jggtz]

Are you using OCX or RDC & Report Viewer to show the report?
The solution is to set the RecordSelectionFormula but the syntax is different depending on which tool you use