Sorting by a different control then grouped by...

[Pat S]

I have a report where records are grouped by the client
they relate to - and on the group header for client I
have a calculated control that generates an invoice date
(based on the first date on the detail)

As it stands now, the report sorts the records
alphabetically by client name, but i really want it to
sort by the invoice date instead -- how do I do this?

Pat

 

[SA]

Pat:

Add the invoice date field before the Client field in the sorting and
grouping dialog.

 

[Pat S]

That doesn't work because it messes up the dates by which
other things are grouped