Solved

Create a report using Crystal reports with unlinked tables

Posted on 2008-10-31
1
950 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 22851517
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
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.
Suggested Courses

738 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