Suppress fields

[jwithers]

I use a SQL 7 stored procedure to return data to a crystal 9 report. The data contains an 'Date Paid' field. I want to suppress the date returned if it is equal to a certain value. I know you can suppress if blank but can you do it if it is populated.

Thanks for any help in advance.

[malleyo]

If you're creating you report files with the designer in VB, right-click on the field you want to suppress, Click 'Format'. Click the tab that says 'Common'. The first option you have is Suppress. Leave the box unchecked and click on the button beside it that says 'x-2'. Here's where you enter your formula for a Conditional Suppress. Something like {Date Paid} > '05/25/04' (although I don't know the proper format for dates, you'll have to look that one up).

[jwithers]

Thanks

I was nearly there but didn't have the date formatting correct.