While standard filters are automatically converted into the correct syntax for Crystal Reports, advanced filters must be manually converted using the filter window within Lucity.
A list of conversion conventions is listed below.
Note: For more detailed information, see the Crystal Reports help system.
Lucity Convention |
Crystal Reports Convention |
TABLENAME.FIELDNAME |
{TABLENAME.FIELDNAME} |
In List (“Item 1”, “Item 2”, “Item 3”) |
In [“Item 1”, “Item 2”, “Item 3”] |
Not In List (“Item 4”, “Item 5”) |
Not In [“Item 4”, “Item 5”] |
>= #9/30/2005# (Access) |
>= Date(2005,9,30) |
< ‘9/30/2005’ (SQL/Oracle) |
< Date(2005,9,30) |
> #2:00:00 PM# (Access) |
> Time(2:00:00PM) Or > Time(14,0,0) |