How to get rid of redundant data

[296097]

E210 01 ELK RIVER CONCRETE PROD CO 6550 WEDGEWOOD RDP O BOX 1660 MN 55311-6660 763/545-7473 2001/01/02 10:59:00.00
E190 01 ELECTRIC SERVICE CO OF MINNEAPOLIS 1609 CHICAGO AVE S MN 55404 612/332-1465 2001/01/02 11:01:00.00
E190 01 ELECTRIC SERVICE CO OF MINNEAPOLIS 1609 CHICAGO AVE S MN 55404 612/332-1465 2001/01/02 11:02:00.00
P0019 01 PRECISION PAVEMENT MARKINGS INC 14280 JAMES ROAD MN 55374 763/428-8767 2001/01/02 12:07:00.00
T250 02 TRAFFIC SAFETY SERVICES 47049 SMITH CIRCLE SD 57032 605/368-2275 2001/01/02 12:46:00.00
T250 03 TRAFFIC SAFETY SERVICES 1812 K AVE N (P O BOX 89622) SD 57104 605/373-1202 2001/01/02 12:46:00.00


I do not really know how to get rid of the redundant data. I have tried to use select distinct method and unfortunately that does not seem to help.if someone has an idea other than the one i have tried pls let me know.your help is appreciated

 

[Turkbear]

Hi,
If that is actually some of the data, there is no redundancy that I can see..


Did I miss something?

 

[kutoose]

Did you try
Database -> Select Distinct Records.

Or

If you can do a conditional suppression based on the previous row.
Go to Section Expert, click on detail, next to the suppress, x+2 , type
{Table.Column}=previous({Table.Column}). Here the Table.Column field can be a unique field.


kutoose@yahoo.com

 

[kutoose]

OK I agree to Turkbear,
After haing a closer look, the data is not redundant !

kutoose@yahoo.com

 

[296097]

sorry i was not clear with my question.what i mean was i just want to see a record with recent date.I am using cr 8.5

 

[296097]

If you look closely E190 has appeared two times and i just want to see the record with the recent date one. the only difference b/n the two records is time which is not relevant in this case and i would like to disregard that.
thank you

 

[kutoose]

You can use conditional suppression as explained above. To show the recent data, you may also have to sort the records in descending order.

kutoose@yahoo.com

 

[lbass]

You could go to report->edit selection formula->GROUP and enter:

{table.datetime} = maximum({table.datetime},{table.companyID})

...where {table.datetime} is your datetime field and {table.companyID} is the field that gives results like "E190". You must group on {table.companyID} to use this method.

Or, another approach is to use section suppression. Go to the section expert (format->section)->details->suppress->x+2 and enter:

{table.datetime} <> maximum({table.datetime},{table.companyID})

You can also check "suppress" for the company ID group header and footer.

-LB