Originally Posted by Betsbabe
Task: Creating a report that lists all of our medically disabled employees. Must be a single line report (i.e. can not group and then list underneath).
Problem: Some employees have more than one disability. This causes them to appear multiple times on the single-line report.
From the menubar, choose Report > Group Expert
and group by EmpNumber.
Go to Design Mode, grab the "Group #1 Name" (which should be in the Group Header #1), and pull it down to the Group Footer #1. Then grab the Disability Type which is in the Details section and drag it down to the Group Footer #1.
Right click on the Details item on the left and change it to "Suppress (No Drill-Down)". You'll probably want to do a little formatting changes, such as changing the "Group #1 Name" from boldface to lightface, but this should provide the output needed.
I would undo the effort taken with the Section Expert and return it to its default setting. HTH.