I want to create separate reports from select data entry groups

[Guest]

I'm working on an emergency call list that covers several departments for my
company. Each department, which I've grouped, is going to have different
criteria for sorting in order to display a unique call order. Some
departments will sort by seniority, some will sort and so I'm wondering if
it's possible to create separate reports for each department and have those
reports include the data for one group so that I can set the sort for each?

 

[Guest]

one method would to simply set up a different query for each
department....that of course allows each to be sorted as one wishes...

and then source a different Report on each query....

 

[Duane Hookom]

You should add a numeric field to your department table that identifies the
field from the call list query that determines the sorting. Add this field
to your report's record source and set your sorting level expressions to:


Level 1: [Department]
Level 2: Choose([CallListSortField], [Seniority], [LastName] , [OtherField])

This would allow for three different sort orders in a single report based on
the employees department.

 

[Guest]

Thanks for your responses, I'll give those ideas a shot and see how I fare...