[SOLVED] InfoAssist 8201 - Create a filtering condition
Creating a report in InfoAssist 8201. To create a filter I drag a field from the Data Pane into the Filter Pane (or click on the Filter button within the Data Tab :>).
Next, the "Create a filtering condition" dialogue box pops up with 6 tabs along the top. The tabs are:
New Filter New Expression Insert Before Insert AFter Group Ungroup
I have not had much luck finding documentation on the "New Expression" option. Can anyone explain it ?
Thanks!This message has been edited. Last edited by: FP Mod Chuck,
Expression merely allows you to code logic yourself instead of forcing you to pick it from the drop downs in new filter. For instance, you can have the following expression:
WHERE CAR.BODY.RETAIL_COST - CAR.BODY.DEALER_COST GT 1000;