print duplicate records only

[stevesd]

Is there a way to be sure I select the duplicate records and print them both, not just the second one?

 

[Hubajube]

Can you add views to your database?

 

[stevesd]

Since I'm not quite sure what you mean by that, I guess not. It might help to review what I have done. I have the records sorted by the appropriae field, account number, and have formatted the details section using the previous function. So, if the previous ({Acctnumber}) = {Acctnumber} it means the record should print. the way I did that was to suppress printing on the details section, then it is false if the above rule is found to be true. The result has been that second record prints, but not the first.

 

[Naith]

Assuming you have no use for the records that you're suppressing, perhaps you should just eliminate them at record selection level, by selecting records where count({acctnumber}) > 1.

Using a full dataset like you're doing now, you'd have to employ a formula which justifies both the first and second prospective duplicate record.

i.e. Conditionally suppress on:
If OnFirstRecord
Then
{acctnumber} <> next({acctnumber})
Else
If OnLastRecord
Then
{acctnumber} <> previous({acctnumber})
Else
{acctnumber} <> next({acctnumber}) and
{acctnumber} <> previous({acctnumber})


Naith

 

[rogar]

if you want to print both records with the same account number, you also need to print when Next({Acctnumber}) = {Acctnumber}

 

[kenhamady]

Naith is close, but used a grand total.

Group on the duplicate field (account number). and put the following in your group selection formula:

Count ({AccountNo},{AccountNo}) 1 Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[kenhamady]

Sorry, should have said

Count ({AccountNo},{AccountNo}) > 1 Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com