[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

Combining two rows of data into one row - Crystal 2008

I have the following data coming into the report
          Name          Address
          JANE DOE    Maine St.   Loke, Texas 12345

          Name           Email Address
          JANE DOE     jd@email.com

I want to display on the report like this
Name               Address                                       Email Address
JANE DOE         Maine St.   Loke, Texas 12345    jd@email.com

0
cookiejar
Asked:
cookiejar
2 Solutions
 
peter57rCommented:
Are you saying you have two tables as the source for your report?

If so you should be linking them on the 'person id' field in each table and you can then select data from either/both tables.
0
 
mlmccCommented:
Is it multiple tables as above or do you have multiple records in one table?

mlmcc
0
 
cookiejarAuthor Commented:
Multiple records in one table.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
mlmccCommented:
WHat columns are there?

I am guessing it is something like

Name
AddressType
Address

mlmcc
0
 
cookiejarAuthor Commented:
Name
Address_Type
Email_Type
One Row of data may have
Doe, Jane   Address: P.O. Box 202 Beaverton, Or 93810
2nd Row of data may Have
Doe, Jane,   Email: janedoe@hotmail.com
0
 
mlmccCommented:
Is the Address type vlue as shown or just the address?

Group by Name
Drop the fields on the report
Right click Address_Type
Click INSERT SUMMARY
Chose summary type as MAXIMUM
Put it in the group footer
CLick OK
Drag it to the group header

Similarly for Email_Type

Suppress details and group footer

mlmcc
0
 
cookiejarAuthor Commented:
Just the address is shown
0
 
GJParkerCommented:
You're not being very clear on how your data is held is it

Name           Address_Type             Address
Doe, Jane     Address                  Maine St.   Loke, Texas 12345    
Doe, Jane     Email                  janedoe@hotmail.com 

Open in new window


If it is then create 2 formulas

//@Address
If Address_Type = 'Address' Thne
    Address


//@Email
If Address_Type = 'Email' Thne
    Address


Add the 2 formulas to the details section of your report and insert MAX summary at the Name Group level.


If your data isn't in this format then please clarify using the same format I used.

HTH
0
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now