Suppress records while using Record Number special field

[jkellington]

Hi,


I'm trying to do what I thought was a relatively simple thing using CR10. (I'm a relatively simple CR user, so keep that in mind)

I have a very straightforward CSV file containing two fields: [name] and . I just want a simple list of the anema nd e-mail fro each record, numbered consecutively (I am using the Record Number field to do my consecutive numbering) There are duplicate records in the data that I would like suppressed.

Now, I can suppress each field if duplicate using format field, but my problem comes in when I want to suppress the entire record, because there is a record number value for that record which prevents the "Suppress Blank Section" option from wotking properly.

ANy suggestions as to a formula or some other method that will allow me to suppress an entire record and still be able to consecutively number the remaining unsuppressed records?

Thanks for the help, hope I've made it clear enough.

Jason

 

[lbass]

Use a formula like the following instead of recordnumber:

whileprintingrecords;
numbervar cnt;

if onfirstrecord or
{table.field} <> previous({table.field}) then
cnt := cnt + 1;

-LB