Sorted field value in report doesn't show up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a report that I created with contact information for people, I am sorting
the records by first name. When I run the report, all of the information in
the report shows up except in the case of duplicate values.

For example, if there is more than one person with the first name, "Eric",
the first record's first name value shows up in the report, but all
subsequent Erics do not show up, only their last name shows.

Some additional information:

There are NO grouping levels.
I am sorting by first name ascending and then last name ascending.
I know ALL of the records contain values for First Name.
When I change the sort to last name first, then first name, the values show
up for First Name, but if there is more than one Last Name record with the
same value, consequent records do not display in the report.
It only occurs when there are identical values for the sorted field.
When I add an additional distinguishing character to the field, the values
again show up in the report (i.e. Eric1, Eric2, Eric3...etc.).

Any advice would be appreciated.
 
tk said:
In a report that I created with contact information for people, I am
sorting the records by first name. When I run the report, all of the
information in the report shows up except in the case of duplicate
values.

For example, if there is more than one person with the first name,
"Eric", the first record's first name value shows up in the report,
but all subsequent Erics do not show up, only their last name shows.

Some additional information:

There are NO grouping levels.
I am sorting by first name ascending and then last name ascending.
I know ALL of the records contain values for First Name.
When I change the sort to last name first, then first name, the
values show up for First Name, but if there is more than one Last
Name record with the same value, consequent records do not display in
the report.
It only occurs when there are identical values for the sorted field.
When I add an additional distinguishing character to the field, the
values again show up in the report (i.e. Eric1, Eric2, Eric3...etc.).

Any advice would be appreciated.
Click to expand...

Sounds like you have HideDuplicates enabled on that control.
 
Back
Top