Duplication of records 1

[buyerbev]

How do I stop the duplication of data? Instead of duplicating I would rather the fields remain blank using 7.0.

 

[MalcolmW]

Select the field you want to conditionally suppress. There is the &quot;Suppress&quot; option under the Format option of the right mouse button menu. Select that, then click on the formula icon to the right of it. Enter the following formula in the formula editor box that pops up.<br>
WhilePrintingRecords ;<br>
Previous({database.field1}) = {database.field1}<br>
<br>
The seagatesoftware.com website has a searchable database of common and not so common questions, and I have found it very valuable.<br>
<br>
<p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>

 

[emcevoy]

Hello

Another way of doing this is to right click on the field go to Format Field and then click on the Common Tab. Place a check in the &quot;Suppress if Duplicate&quot; option.

Hope this helps. E. McEvoy
Crystal Reports Consultant

http://www.pacificridgesolutions.com