Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Joining 2 records Post Reply Post New Topic
Author Message
cottie
Newbie
Newbie
Avatar

Joined: 07 Nov 2007
Location: Philippines
Online Status: Offline
Posts: 3
Quote cottie Replybullet Topic: Joining 2 records
    Posted: 07 Nov 2007 at 12:20am
Hi!
 
I am new in this forum hope everyone is willing to help me.
 
I am having a problem with my report. I wanted to combine two records in one column. Here is a sample column in my table
 
Org_ID            Company       Contact
1                           ABC              --
1                                               maria
2                            XYZ              --
2                                                Don
 
With that I wanted my report to look like this:
 
Org_ID          Company                             Contact
     1                  ABC                                     maria
     2                  XYZ                                      Don
 
Is it possible to do it? I am using Crystal Report 9.
 
Thanks for your support.
IP IP Logged
MRVbnet2005
Newbie
Newbie
Avatar

Joined: 07 Nov 2007
Location: Philippines
Online Status: Offline
Posts: 1
Quote MRVbnet2005 Replybullet Posted: 07 Nov 2007 at 12:39am
u create store procedure that joining in sql statment
IP IP Logged
cottie
Newbie
Newbie
Avatar

Joined: 07 Nov 2007
Location: Philippines
Online Status: Offline
Posts: 3
Quote cottie Replybullet Posted: 07 Nov 2007 at 1:22am

My back end is dbase.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 08 Nov 2007 at 12:13am
This would require a tricky formula. I would save the Company field to a global variable. Then suppress the Detail section when the Contact field is empty. When the contact field isn't empty print the value of the variable that is storing the Company field.

That way the first record will always get suppressed and only the second record gets printed. The second record will print the company name with it since it is pulling the data from the previous record that was stored in the variable.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 08 Nov 2007 at 2:00pm
Does dBase support SQL queries?  If it does,  you could write a query that simply grouped the data? I dont have a copy of dBase or similar xBase database,  which is why I can't answer the question myself. 
 
Failing that you may be able to create Command Objects pulling the Id and CompanyName in one and then the Id and Contact Name in the other then use the Database Expert to link the two command ojects by  the Id?
 
I also do not have v.9 so I dont know if did not have the Command Object functionality.
 
 
John W.
 
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.