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

Register | Login 

Sunset Ride 
Sunset Ride 

General Notice: BOB is going to retire...please see details here. All BOB forums have been converted to "read only" as of September 1st.
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 

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0276 seconds using 17 queries. (SQL 0.0032 Parse 0.0008 Other 0.0236)
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