Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    5

    Unanswered: Stumped with repeating items in 2 joined DB's

    I have a somewhat simple problem but it's bugging me to death. I can't get around it.

    I'm using Crystal reports 9.2.

    EXAMPLE:

    Customer table
    Order Table

    I want customer names listed from the Customer Table where there was an order sent to Florida (which is identified in the ORDER TABLE)

    ORDER TABLE is linked to CUSTOMER TABLE with an inner join.

    Every time I run the report the customers name lists multiple times (If 5 orders were found then the name lists 5 times.)

    No matter how I mess with the joins I get the same results.

    How can I get around this. I only want the Customers Name to list a single time -- not once for each order that met the selection critera.

    I would REALLLLY apprecate any advice here.

  2. #2
    Join Date
    Oct 2005
    Posts
    178
    Create a group section for the Customer field name from Customer table, leave ORder fields in details section

Posting Permissions

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