Report does not show multiple matches

[Guest]

I built a report from a query. When I run the query I get two name matches.
But, the report will only display one of the matches.

Report design is as follows:

"Hide Duplicates" property is set to no.
“Last Name†Header.
Under “Sorting and Grouping†I have the following settings:
Last Name “Ascendingâ€
Group Header: Yes

Note: If I use “CustomerID†instead of “Last Nameâ€, then all of the records
are output in the report (including the ones with duplicate names)

 

[Wolfgang Kais]

Hello "jsccorps"

I built a report from a query. When I run the query I get two name
matches. But, the report will only display one of the matches.
Report design is as follows:

"Hide Duplicates" property is set to no.
"Last Name" Header.
Under "Sorting and Grouping" I have the following settings:
Last Name "Ascending"
Group Header: Yes

Note: If I use "CustomerID" instead of "Last Name", then all of the
records
are output in the report (including the ones with duplicate names)

You have probably hidden the details section that displays the two
records for that group (same last name).

 

[Guest]

Thanks for responding. I am not using the Details section (i.e., it is
blank). I checked, and the Details section is not hidden. I am using a
"Last Name" Header section to produce the report. I am and sorting and
grouping within the Header section. Output looks as follows:

"Last Name" First Name"
"CustomerID"

"Last Name" First Name"
"CustomerID"
....

(If I use "CustomerID" instead of "Last Name" as the Header, then all of the
records are output in the report (including the ones with duplicate Last
Names])

 

[Wolfgang Kais]

Hello "jsccorps".

Thanks for responding. I am not using the Details section (i.e.,
it is blank). I checked, and the Details section is not hidden.
I am using a "Last Name" Header section to produce the report.
I am and sorting and grouping within the Header section.

[...]Output looks as follows:

That means that you let the report build a group for every "LastName".
The group header is displayed only once, that's why a LastName
appears only once.
Don't use grouping in your scenario, just use the details section.
Or group by CustomerID but display LastName in the CustomerID Header.