Print Page | Close Window

Combinding Fields

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12816
Printed Date: 06 May 2024 at 10:30am


Topic: Combinding Fields
Posted By: Roesing
Subject: Combinding Fields
Date Posted: 05 Apr 2011 at 8:20am
I have exported a report using Raiser's Edge, this exports to an Access Database. In Access there are several tables. In one of the tables there is Name, Lastname in the second table there is GuestName, GuestLastname. I need to combined the Name field and Guestname field so I can make a check in list. 

Is there anyway in Crystal to write a formula or is there an application in crystal that will do this.  I can do this easily in excel or access but I want to pull it back into Raiser's edge so it needs to happen in crystal. 

Thank you for any help.  I have Crystal Report 8.5


Replies:
Posted By: hilfy
Date Posted: 06 Apr 2011 at 4:08am
If I understand you correctly, you want a list of all the names regardless of which table they come from, correct?
 
In Crystal 8.5, there is an option to edit the SQL that Crystal generates.  You'll need to take this option and do a query similar to the following:
 
Select "Table1"."Name", "Table1"."LastName
from Table1 as "Table1"
 
Union
 
Select "Table2"."GuestName", "Table2"."GuestLastname"
from Table2 as "Table2"
 
The data from both tables will come through with the field names from the first table.  You may have to tweak the query a bit to get it to work - I haven't worked in 8.5 in a number of years so I don't remember exactly how it wants things set up.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window