Trying to find a negative to "in". 1

[yorrick]

THis is simple I'm sure but has got me struggling.

I want to suppress some fields dependant on whether a field falls within the date parameter field.
If it does fall within I want the field suppressed.

This provides the OPPOSITE of what I want when put into the object_visibility editor.

{Contact2.UBYWHN1) IN {?date)


I cannot use
{Contact2.UBYWHN1) NOT IN {?date) what is my alternative?

 

[Naith]

NOT {Contact2.UBYWHN1) IN {?date)

 

[dgillz]

Why do you want to suppress those fields? Would it not make more sense to exclude them from the report entirely? Please keep in mind that suppressed fields will still evaluate in any sub or grand totals that your report has. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[yorrick]

Unfortunately I get

"Boolean expected here" after the 'not' for this solution.

?date is a date-range field and I'm using Crystal Syntax.

The reason I want to suppress is because I have a list of Managers in the details section. There are 3 objective fields in the database (obj1....obj3) and I only wish to show objectives that have been completed in a certain time frame. A manager could have 0,1,2 or 3 objectives completed but either way I always want to show the manager.

 

[pelajhia]

try NOT( {Contact2.UBYWHN1} IN {?date} ) - with parentheses.