Hi,

I currently have a report which groups on PO numbers. Within the group you can potentially have multiple dates. What I would like to do is create a separate field which looks at the date field of the grouped PO and if the PO contains dates which aren't the same then add a flag field to show this.

Can anyone help me please?

Thanks as always

You probably would have to group on the date and move the fields to the GF and  suppress when a counter is equal to 1 (suppress details all together).

Using a running total and suppress the GF based on that running total (i.e., {#some running total} = 1  ).  As far as the criteria for the running total, I am not totally sure based on what information you have provided so far.

Relationships are based on the table structures.  In most cases there is only one relationship.  If you are getting duplicated data, you may need to have second (third, fourth, etc.) relationship (if possible).  If you are using a command or stored procedure, there are other 'tricks' to minimize the amount of data that will be returned to a report.