Crystal Help - Union in Crystal

Posted on 2013-10-04
Medium Priority
Last Modified: 2013-10-08
I have to design a report such that-
I have 2 tables RXS and HRXS, they are joined on rx#,patient# and facility#.
When displaying I have to display data from both rxs and hrxs table like a union all.
Is it possible in crystal?
Please advice.
Question by:Star79
1 Comment
LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 39547457
Joining indicates these is a relationship you wish to use between the tables like an SalesOrder and SalesOrderDetails

SalesOrder has the SalesOrder # and information on the customer while the details has the details of the order.  

Generally linking like this is between tables that have different data

A desire for a union would indicate the tables have the same data columns for instance one being Open Orders and the other being Fulfilled or Closed Orders

You can do a union in Crystal in 3 basic ways
1.  Create a view/stored procedure in the database that unions the data

2.  Use a Crystal COMMAND as the source like
      SELECT RXS.RX#, RXS.Patient#, RXS.Facility#  FROM RXS
     SELECT HRXS.RX#, HRXS.Patient#, HRXS.Facility#  FROM HRXS

3.  Use the RXS table for the report and group on The common fields
      In the group footer insert a subreport that uses HRXS as its source and link on the common fields


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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …

600 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