Solved

Create a report using Crystal reports with unlinked tables

Posted on 2008-10-31
1
931 Views
Last Modified: 2013-11-15
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
Comment
Question by:aftsupport
1 Comment
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

744 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

12 Experts available now in Live!

Get 1:1 Help Now