Reporting with Advanced Filters

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)

See Also

Advanced Reports

Creating Custom Reports

Tables

ODBC Connection

Date and Time Fields

Displaying Images

Report Parameters