Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008
    Posts
    3

    Unanswered: How to link the tables

    I am using Crystal Reports 10 for my job.
    My latest report uses two tables and a view but it produces millions of records probably because of bad table linking.
    Is there any tool or method that helps in table linking?
    As you understand smart linking of crystal reports is not so smart because it generates the links based only on same field names.
    Thank you!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    generating the links based on same field name can be disastrous when more than one table has a column called "id"

    unfortunately it is going to have to be you who provides the correct links

    the tool or method is called "understanding your tables"

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Just another good reason to triple check your table linking
    George
    Home | Blog

Posting Permissions

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