BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Convert two rows as a one row in Crystal report


 
Search this topic... | Search Crystal Reports... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Author Message
emmapiva
Forum Member
Forum Member



Joined: 31 Aug 2019

Posts: 1



PostPosted: Sun Sep 01, 2019 2:40 am 
Post subject: Convert two rows as a one row in Crystal report

I would like to convert two rows of data into one row in Crystal report. Please see below scenario.

I got two tables Employee and Address
Employee
EmployeeNumber, Employee Name, Employee Department
1001, Sam, IT

Address
AddressID,EmployeeID,AddressType,Address
100, 1001,Postal, 23 Edgards road wollert
101, 1001, Residential, 52 Shields street Wollert

I want the report looks like below without using stored procedure
Employee Number, EmployeeName, Postal, Residential
1001, Sam, 23 Edgards road wollert,52 Shields street Wollert

Thank you in advance
Back to top
kondapally
Forum Member
Forum Member



Joined: 13 Feb 2020

Posts: 2



PostPosted: Thu Feb 13, 2020 4:06 pm 
Post subject: Re: Convert two rows as a one row in Crystal report

join 2 tables on employee id and you will get only one row per employee (provided employee has only 1 address)
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0268 seconds using 17 queries. (SQL 0.0025 Parse 0.0008 Other 0.0235)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo