Crystal Reports - Duplicate records

Posted on 2011-10-28
Last Modified: 2012-05-12
Attached is the report with the data; how can I suppress the duplicate information?  I tried Suppress if Duplicated but it did not work! Please advice. Thanks
Question by:rustypoot
    LVL 100

    Expert Comment

    Try using the SELECT DISTINCT RECORDS option under the DATABASE menu

    LVL 14

    Expert Comment

    If they are at the row level, you could try something like this on the detail section (right click, section expert, then hit the x2 by SUPPRESS)

    if {table.field} = next({table.field})
    then yes
    else no
    LVL 19

    Accepted Solution

    Create a group at the level that is causing the duplication, in your report it looks like yuo will need 2 groups patient_id and care_event_counter and move the fields into the group 2 footer and suppress the details section.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now