Topic: Remove Duplicate lines in crystal reports Posted: 10 Jul 2008 at 2:30am
hi
I have a report based on one data table ... lets call it MRPLOG. The MRPLOG table holds a item called Part - this links nicely to a data table called PURCHITEMS which has a item called P.Part - this data table links to a 3rd table called PURCHORDERS - purch orders holds the all important VENDOR Code I need to add to my existing Crystal 9 report.
the report (solely based on the MRPLOG file) is working well and running at around 700 pages long - when i add the Vendor Code from the Purchorders table, the page count jumps up to 4500 pages. Looking at the data it is showing duplicate records - I need to remove these duplicate records and i cant - tried the old 'suppress if duplicate' but that only removes the field - i need to remove ( or suppress) the whole line.
please, if a question from you, would in the end help me... please ask it!!
Paul
Birmingham
England
{A friend in need is a pain in the a***}
tried that however the report is now showing the vendor only supplying one part to us instead of a list of parts with their vendor - i think this may be down to the way the ERP system (efacs) is supplying the data to the report - the report is solely based on one datafile and links data tables to pull in the required data.
I could do this in another ERP System ( Sanderson PICS) using a 'join' dictionary item but its different in efacs/crystal reports. So after working on this for a couple of days, i have given in and asked our ERP Vendor for a quote to do the work.
but thanks for your help anyway Sarah!
Paul
Birmingham
England
{A friend in need is a pain in the a***}
i played around with the field name to 'suppress on duplicate' and by jove it works when you use the serial number to the first data table as the unique suppressor.
many thanks for you help Sarah!
Paul
Birmingham
England
{A friend in need is a pain in the a***}
Joined: 25 Jul 2008
Location: United States
Online Status: Offline
Posts: 1
Posted: 25 Jul 2008 at 8:24am
I am having a similar problem with CR XI. I have a table (jobdwgbm) that i am pullilng seq#, desc, and weights from. i also am pulling "codes" from a second table (jobcutr). when i put the codes field into the report i am getting duplicate records. i am assuming it is from the join. please help!
Joined: 26 Apr 2011
Location: United States
Online Status: Offline
Posts: 3
Posted: 26 Apr 2011 at 4:40pm
OMG! I could just kiss you on the lips Sarah! I have been trying to solve this issue on very complicated report on sales invoices combined with costing and payroll for years! I used your solution to suppress the duplicating line item id and wah lah! Thank you so much for sharing!
Joined: 07 Jun 2011
Location: United States
Online Status: Offline
Posts: 2
Posted: 07 Jun 2011 at 10:10am
Sarah, I cannot thank you enough for the solution. The part that makes it so great is after you try it and it works it is just so amazingly simple and logical.
Thanks
You can not know everything but you need to know how to find out!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
