Alpha Video Training
Results 1 to 3 of 3

Thread: Duplicate records printing on report

  1. #1
    Member Rolin's Avatar
    Real Name
    Rolin
    Join Date
    Feb 2007
    Posts
    24

    Default Duplicate records printing on report

    I have a report that uses a Set that contains a main linked table with two foreign keys to a second linked table. The second linked table has a normal link to the first foreign key, and the second foreign key is linked via an alias in the Set.

    When I generate a detailed / tabular report, using the said Set, it duplicated the records of main linked table.

    I also tried to create another linked table to the same data source & table as the second linked table, and not use an alias within the Set, but still have the same error.

    Any ideas on how I could resolve this?

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default Re: Duplicate records printing on report

    You probably have fields from the primary table of your set positioned within the details band / region of your report layout.

    When your report is based on a one-to-many set you probably should insert a group break based on the primary key in your primary table. Then place fields from the primary table in the group header region, while placing fields from the linked child table in the group details region.

    See: "Designing Reports for Sets with One-to-Many Links" in the User's Guide for additional information.

  3. #3
    Member Rolin's Avatar
    Real Name
    Rolin
    Join Date
    Feb 2007
    Posts
    24

    Default Re: Duplicate records printing on report

    Thanks for the info Tom,

    Unfortunately, my report needs to have a many-to-many relationship...

    I resolved the issue by creating 2 commands that merges the data from the secondary table [both instances of them] into the primary table... and then use that for the report source.

Similar Threads

  1. Printing invoice on report - duplicate lines
    By alex in forum Alpha Five Version 6
    Replies: 2
    Last Post: 02-24-2006, 08:05 PM
  2. Duplicate records in report
    By Bob Wily in forum Alpha Five Version 6
    Replies: 5
    Last Post: 10-17-2004, 10:44 PM
  3. Duplicate Records On Report
    By Sam Berger in forum Alpha Five Version 5
    Replies: 1
    Last Post: 06-28-2004, 10:57 AM
  4. duplicate records on report
    By Scott Rusoff in forum Alpha Five Version 5
    Replies: 1
    Last Post: 12-17-2002, 06:26 AM
  5. Invoice summary report printing duplicate records
    By Alex Levy in forum Alpha Four Version 6 and Prior
    Replies: 1
    Last Post: 10-03-2001, 03:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •