Displaying grouped records in specific order

B

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
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing group totals in the page or report header 4
I want to create separate reports from select data entry groups 3
Showing a zero on a report when no underlying query records found 2
Sorting a Report 1
Calculation In A Report 2
print some pages in a report n times 2
Grouping and sorting 14
Hide Header if its Subreport Has No Records (A2002) 2

Top