Link to home
Avatar of Bloodrule
Bloodrule

asked on

Alphabetical sort in group footer won't work

I have a table of names sorted alphabetically.  I wanted toI group them in a report so that each section starts on a new page.  For example, at the end of the names starting with "A" a new page start with names starting with "B", and so on.

In report design I clicked Sorting and Grouping button and chose the name field from the dropdown list.
Chose Yes for group Footer.
Chose Prefix Characters for Group On
and 1 in the next box.
Closed the dialog box.

This has successfully segmented the report so that lastnames are segmented alphabetically, but WITHIN each group I have lost the alphabetical order, even though the table from which the report is derived is sorted alphabetically.

Why has the group footer that I have created messed up the alphabetical order that was there before I added the group footer?
ASKER CERTIFIED SOLUTION
Avatar of harfang
harfang
Flag of Switzerland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial