I am trying to create a report where the records are being grouped by a field. The report will displey the groups correctly only if the records are sorted by the field by which the grouping is done by. How can I sort the records automatically so the user doesn't have to sort manually? The report has to be done in preview mode and there if I insert a button cannot be pressed. Can I sort the fields automatically?

Thanks,

Evan

1. Perform your Sort.

2. Create a Script that includes the Sort (Restore) step. The script can also:

Go to Layout (your report)

Preview (Pause)

Print (with or without dialog)

Browse

Go to Layout (original layout)

etc.