Filter Date Parameters

[GP777]

I created a report from SQL view. I am trying to create date prompt; but the crystal is not filtering the data by date. Is there a special formula that crystal needs for date prompt?

 

[synapsevampire]

Since you didn't share what formula you used, I'll just supply a generic overview:

Create a parameter of type date (I'll refer to it as MyDateParm).

Select Report-Edit Record Selection->Record

Now place something like:

{MyTable.MyDateField} >= {?MyDateParm}

This will filter rows to only those greater than the date entered in the parameter.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com