Skip to Content
0
Former Member
Dec 08, 2008 at 05:15 PM

how to delete the duplicated records, not just surpress the records?

11 Views

I am new to CR. Right now I am doing a project which needs CR get query from Oracle. I got the query from Oracle. There are records with duplicated fields. For example (the following only show part of fields):

ID body_code

1 10

2 10

3 15

4 15

5 15

6 16

I need to only select records (not surpress, because I will do some caluculate later) like following:

ID body_code

1 10

2 15

3 16

I tried to creat selection fomula in fomula workshop, shown as follows:

onlastrecord;

<>next

but CR said next can be evaluated. I think it must have something to do with the print-time. So what show I do to delete the duplicated records.Thank you very much.