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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Suppresion
- Thread starter edmac2
- Start date
You could suppress the fields which are the same as those in the previous record. This is done by right-clicking on the field in the Design View, choose Format Field, click the x-2 box to the right of Suppress, and then enter a formula such as this:
if previous({ado.order_numb}) = {ado.order_numb} then
True
With this formula, the order_numb will appear only if it is different than the order_numb in the previous record.
HTH
if previous({ado.order_numb}) = {ado.order_numb} then
True
With this formula, the order_numb will appear only if it is different than the order_numb in the previous record.
HTH
Group your report by whatever field it is that determines it is a duplicate. Then insert a count summary on that field. Finally, insert a group selection formula, Count({fieldname})>1. This will select only those items with more than 1 record.
Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office
Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office
- Status