Displaying grouped records in specific order

[Bill - ESAI]

Hi All

Here's my scenario:

I have a projects, department table and a report

I display my projects in a report grouped by their department using a header
and foot on the group. Each project are ordered fine but the departments we
want grouped in order of their logical order to us. So I added an order by
field to the department table that linked to the project via the one to many
rel. using the Department ID. I've set the sortOrder field for each
department from 1 to what ever.

What I want is each group (which is group by department) to display in the
order of my sortOrder field.

Any ideas how to sort order a set of groupings??

TY

Bill

 

[Duane Hookom]

Open the Sorting and Grouping dialog in report design view and set the top
level to the department sorting field.

 

[Bill - ESAI]

Thanks Duane

Once I slept on it all came clear.

Bill