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!

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

Suppressing Duplicate records

Status
Not open for further replies.
jlo99

jlo99

IS-IT--Management
Jul 28, 2008
3
US
I am trying to suppress duplicate records on a simple report using v10. In some of the research I have done it seems I may have to write a Boolean formula. I don't know how to do this. Any suggestions?
 
Sort by date Sort by votes
May be you can check the "Select Distinct records "Option in "Report options"
If that's what you are looking for.
Hope this helps.
 
Upvote 0 Downvote
raja2008 that seemed to work, thanks for your help.
 
Upvote 0 Downvote
I never used it.
I'm not sure how it works if you are doing any calculations that needs to work on all the records.

Please test it and make sure .
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
212
socalvelo
socalvelo
nerdygirlgear
  • Locked
  • Question
Limit sub report records to a time range on main report 1
Replies
1
Views
180
hilfy
hilfy
Paulo R
  • Locked
  • Question
CR Running Total distinct count duplicates
Replies
9
Views
386
Paulo R
Paulo R
jlr123
  • Locked
  • Question
Formula for suppressing rows
Replies
3
Views
198
lbass
lbass
peaches9531
  • Locked
  • Question
Formula for multiple records selection criteria in Crystal
Replies
3
Views
407
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top