Group but do not Sort (1 Viewer)

RichMorrison

Registered User
Joined
Apr 24, 2002
Messages
588
Greetings All,

The record source for a report is a query. The query selects Projects and, for each Project, all the Activities. The Projects are sorted by importance and by date. Within a Project, the Activities are also sorted by importance and by date. The query works just fine.

In the report, I want to force a new page when the Project name changes. A Group Header on project name will accomplish this. But that resorts the report based on project name.

I suppose I could generate a new field in the query that represents some kind of sort sequence.

Does anyone know another clever way to do this ?

Thanks,
Rich Morrison
 

boblarson

Smeghead
Joined
Jan 12, 2001
Messages
32,068
You can force a sort by importance and then by date within that importance by going into sorting/grouping and select your importance first and then add date as the next one (both with headers/footers set to NO) and then put in your project name and select header - YES.
 

RichMorrison

Registered User
Joined
Apr 24, 2002
Messages
588
Thanks Bob

Yup, that'll do it.

Thanks,
RichM
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom