>>I have a field in a report which has a Print When condition. I also want to supress printing of repeated values. However, when you enter a condition expression, the Print Repeated Values radio button becomes disabled.
>>
>>Need some help on how to combine these two features.
>>
>>Thanks to all........Rich
>
>You might use a report variable to count repeated values, and use this variable as part of the "Print When..." condition. The condition might be something with iif().
One way to do this might be to use data grouping on the not-to-be-repeated value. Create a report variable that resets on this group - using count - and only print when this variable = 1.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)