Report - displaying multiple values as a row and column

building reports crystal reports
1

hi guys,

I have a report with approx. 12 columns:
client |name |code|…
Test |John Doe |1234…
Test 2 |Jane Doe |4321

the name is coming from database/ table/ contact type field called “otherparty”
there is also contact type called “Agent”, this is where my problem starts, I need the name of the “Agent” to be displayed as a column like this:
client |name |code|… |Agent
Test |John Doe |1234… |Conor Duffy
Test 2 |Jane Doe |4321 |David Smith

but what happens at the moment is the agents display as a row and therefore create duplicated rows with all other info.
like this:
client |name |code|… |Agent
Test |John Doe |1234…
Test |Conor Duffy |1234…
Test 2 |Jane Doe |4321
Test 2 |David Smith |4321

Please help!

juguete (BOB member since 2017-01-26)

2

Sounds like you need to join the contact type table another time (aliased). You may need to create a command to be able to filter the second table correctly (contact type = ‘Agent’). The other question when you do this, is there always a contact type of Agent, of not then you have to do a left outer join on your main table.

kevlray :us: (BOB member since 2010-06-23)