CAN IT BE DONE? 1

[pjmdesigns]

Hopefully this makes sense:

I have a view, as an example this might display the following:

Company Companyid Holderid

ABC Ltd 001 004
Zeen Ltd 002 004
Americo Ltd 003 002
Ucase Ltd 004 <null>

In the Details section of my report I want to display the Company and Holder, however the Holder must display the actual Company Name of the Holder (noting: The Holderid is a reference to the Exposureid), i.e:

Company Holding Company

ABC Ltd Ucase Ltd (Companyid 004)
Zeen Ltd Ucase Ltd (Companyid 004)
Americo Ltd Zeen Ltd (Companyid 002)
Ucase Ltd <null>

Any ideas how I might achive this?

Cheers
PJ

 

[lbass]

I think you could add the table again as an alias (table_1) and then do a left join from the table to table_1 from {table.holderID} to {table_1.companyID}. Then use the table_1 company name and ID field for your second column.

-LB