Suppress or Exclude end of trip IDs

[capronton]

How can suppress or exclude all end of trip IDs from record selection?

I put the formula below in the suppress detail section but is not working. Can you assist?

If {trip.end_tpid} then 1
else 0

 

[kray4660]

What kind of field is {trip.end_tpid}? Also have you selected 'Default Values for Nulls' in the formula editor? I would think you would want to use the Select Expert.

 

[capronton]

I would prefer to filter records rather than suppress records. How would I put the following syntax in the select expert?

If trip.end_tpid = timepoint.tpid then filter row.

For some reason I'm drawing a brainlock - any suggestions would be appreciated.

 

[ianoctdec]

H,

Try this:
(
If trip.end_tpid = timepoint.tpid then
false //filter row
else
true
)

Dana

 

[capronton]

Thanks Dana. I was able to used the criteria below to filter the records.

{trip_timepoint.tp_id} <> {trip.end_tpid}

 

[ianoctdec]

Ofcourse! Some times we just miss the obvious.

Dana