Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help suppressing a group if it is a duplicate

Status
Not open for further replies.

mvalley

Technical User
Mar 4, 2011
80
US
I have a report based on a group{v_basic_case_rec_data.cr_urn}
I have 4 detail sections within this report. Occasionally I have duplicate records for the same {v_basic_case_rec_data.cr_urn} and I only want to show the first record, and suppress any duplicates based on the {v_basic_case_rec_data.cr_urn}. Would I do this using a WhileReadingRecords formula or something else? Thanks in advance for any assistance. Mary
 
If you always only want to show the first record, then why not place the fields in the group header and then suppress the detail section?

-LB
 
That works...Thank you for reminding me that the simplest solutions are the best.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top