Supress Multiple Records

[govmule]

Hello,

I have a report that has an 'Exit' table with one record for each client. It also has a "FollowUp' table with up to four records for each client (90 Day FollowUp, 180 Day FollowUp, 270 Day FollowUp, 360 Day FollowUp). I'm trying to get the report to show only one record for each client, but show all the followup dates. When I do so I get multiple records for each Client.

I've tried the "Select Distinct Records" option under the database menu as well as placing the 'Distinct' operator in the select statement under "Show SQL"

Any help would be greatly appreciated.

Thanks,

Jack

 

[govmule]

Hello Everyone,

I've solved this problem by reading other posts and creating a new group for a unique field in the client record and placing all detail in that group header.

Thanks for the posts, they really help.

Jack