• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 970
  • Last Modified:

Create a report using Crystal reports with unlinked tables

I have a Crystal Report that displays order information and order details. It has 4 tables that are linked together by different fields - works fine. I would like to add to the header of each page "Company info" from another table. Unfortunately, this company table has no field that I can link it an order. There is only one company table record.
Does any one know how I can attach this company table/record to my report?
0
aftsupport
Asked:
aftsupport
1 Solution
 
mlmccCommented:
You can't.  Since it doesn't have a field to lonk by.

How will you be able to select the single record or foes the table only have 1 record?
If it only has one record you can add it and simply not join it to the others.  You will get a cross-join but since there is only 1 record it won't affect the recordset results.

If there are many companies in the table but only one record per company you could use a subreport to dosplay the information.
You would still need a method of selecting the correct company.

mlmcc
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now