Suppress if duplicated not working on date

[dokken]

I have a date field in my group header. I specified supress if duplicated and it still shows duplicate dates. Anyone know how to suppress duplicate dates?

Thanks
Paul

 

[FoxG]

Hi,

Group on the data
Put the fields in the header or footer
Suppress the header and details as required

Hth,
Geoff

 

[dokken]

I do group by this field and it is in the header. It still shows duplicates. How do I tell it to supress duplicates?

 

[Ngolem]

I think "Suppress if duplicated" only works in the detail section

In the header I use the conditional suppress of the field


In the PrintState functions you will find Previous()
so I would put the following in the conditional suppress


not onFirstRecord and
Previous ({table.field}) = {table.field}

The "Not onFirstRecord" prevents problems when you first start the report

hope this helps
Jim

 

[FoxG]

Hi,

If you are grouping on a date field and still getting duplicates then you may have a higher level group which is overriding your date group.

Hth,
Geoff

PS. If you still need to suppress these records then you can create a running total for the date field and suppress the section if greater than 1.