sorting separate pages in a report

Kluft

New member
Local time
Today, 09:46
Joined
Jul 17, 2003
Messages
7
I'd appreciate it a lot if you could help me with these 2 problems:
1. I have a report that includes a first name and a last name for several customers. The problem is that I have to sort this report in an ascending order first by the last name and then, by the first name within the last name group. How can I do that?
2. Within the same report I have a group of several customers that have the same last name, and for these customers the first name appears only at the first one in this group- for the rest, only the last name appears. How can I change so that all the first names appear?
Thank you in advance!
 
To sort in a report, use sorting and grouping - from the menu "View" - "Sorting and Grouping". In the box that appears, select the fields you want to sort by, in the order you want.

Re the first name not appearing, is the "Hide Duplicates" property set to "Yes"?
 
The option for "Hide Duplicates" is set to NO(for all the fields in the report). Should it be set to "yes"?
As for the sorting issue, I was trying to sort in ascending order the first 7 pages in the report by the last names, and the last page by the first name. My question would be how can I establish this differentiation by pages and not by fields in particular.
Thanks in advance for any solution.
 
The Hide Duplicates property should be set to "No" - can't think off hand why duplicates would be supressed if it's set that way. Is this a straight-forward report based on a query or table? Any funky code you were trying or anything? Anything unusual with the underlying data?

Re sorting - you can't change sort order after printing has started. Can you differentiate which names should be sorted differently in some way and put a sub-report on the last page?
 
The report is based on a table. The thing is this sorting is not actually related to the pages themselves, and I wouldn't have any problem with the sorting if it weren't for that requirement. It says there that the last group of names should be sorted alphabetically by the first name. There are like 3 groups on a page, that's why I thought the sorting would be by page.
I add that I've already sorted my report alphabetically by the last names, so all that's left is that page with the last 3 names that must be sorted by the first names.
Thanks for your time!
 
Are the names that must be sorted by First Name particular names, or just the last ones on the list?

If there is a way you can specify which names are in that group, for example are they all managers, all professors, all whatever - then you can base the main report on a query that excludes the sort-by-firstname-group.

One way to do this would be to make the record source of the main report something like "Select * From tblPeopleOrWhatever Where Title <> 'Manager'; (better the ID for the description Manager). Then a subreport could have recordsource "Select * From tblPeopleOrWhatever Where Title = 'Manager';"

If there is no common group but you know which people should be in the first name group, add a yes/no field to the table, Selected, then check the ones you want to be in the group.
 
Great! I finally figured it out..with your help, of course. Million thanks for your time and your help!!:D
 

Users who are viewing this thread

Back
Top Bottom