There are a few ways to accomplish this, which all basically do the same thing.

{MyReport.MyDate} < {?EnterDate}

{MyReport.MyDate} IN UpTo {?EnterDate}

{MyReport.MyDate} BETWEEN '01/01/1970' AND {?EnterDate}

The first one is pretty simple, and I think is the one that Crystal will create by default with the Select Expert.  The second uses the range operator UpTo, which you can check out in the help file.  The third is particularly useful if you want to exclude bad dates in some way.

you can filter the records by using the select expert option in report menu. select the field based on which u want  to filter the data.  after that select the appropiated condition (i.e greater than,  less than etc) and the select your paramter.  based on your condition your records are filtered.

As a note, you can use SQL in Crystal (assuming the database supports it).  When selecting your data source, instead of selecting a table or view, select Add Command.  This allows you to enter your own SQL.

Which, given your requirements, may be desired.

For straightforward selection criteria, you may be out of luck (or, at least, out of your depth).  However, there is a relatively simple workaround.  Using the criteria you have now, group your report on student.  Put suppression criteria on the group and details section that look like:

Maximum ({ViewExamHistESOL.ESOLExamHistSess} ,{ViewExamHistESOL.StudentID}) <> {?Session}

That will hide any student who is not enrolled this year.  Note that the data is still pulled for all students, so there is still the performance hit (and possible storage hit, if you are saving the data with the report).  But, it does provide the results you are looking for.

Can anyone out there help me? I'm well and truely stuck!!

Edited by Lewe22 - 09 Jan 2008 at 3:24am