Hi,
First, the givens:
Crystal version = various (8.0, 8.5, 9.0)
Database/connectivity used = ODBC to AS/400
Example data: Total Amount Due is created from a running total field so its value will either be zero (0) or some number > 0
Expected output: Reports where Amount Due is greater than zero
The scenario is that I have a report that calculates account statements. We only want to display/print those statements where the balance due is greater than zero. The Amount Due is calculated as a final running total less a discount. How can I display/print only those statements where the amount due > 0? The Amount Due formula field does not show up in the selection criteria since it is based on a running. Any ideas/help would be greatly appreciated.
Thanks,
Tom
First, the givens:
Crystal version = various (8.0, 8.5, 9.0)
Database/connectivity used = ODBC to AS/400
Example data: Total Amount Due is created from a running total field so its value will either be zero (0) or some number > 0
Expected output: Reports where Amount Due is greater than zero
The scenario is that I have a report that calculates account statements. We only want to display/print those statements where the balance due is greater than zero. The Amount Due is calculated as a final running total less a discount. How can I display/print only those statements where the amount due > 0? The Amount Due formula field does not show up in the selection criteria since it is based on a running. Any ideas/help would be greatly appreciated.
Thanks,
Tom