Sorted field value in report doesn't show up

T

tk

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.
 
R

Rick Brandt

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.

Sounds like you have HideDuplicates enabled on that control.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top