How do I filter records based on a formula?

[PTW]

I'm using Crystal Reports 7.0 and I'm trying to use a filter to show only records that have whole dollar amounts (no pennies) in a field called Doc_Amount.

I created the following formula:
Right(ToText(Doc_Amount), 2) = "00"

Now, how do I use this formula to filter the records, or should I be using a different method altogether? Thanks for any help! [sig][/sig]

 

[kenhamady]

First, place this field on the report and make sure that you are getting the Boolean values on the right records. I would have used the Remainder function which is cleaner. or maybe:
field = Truncate(Field)

But, anyway, once you get the boolean to work on the right records, then you open the select expert (report - select expert) and add a rule that uses your boolean field; something like
{@myboolean} is True.

Or you could open (report - edit selection formula) and simply insert the field as the formula, since it is already a boolean. [sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Taining by Ken Hamady</a><br>[/sig]