Unable to display different relationship types in different columns

[Paul12345671]

Hello,
I'm new to CR, but I'd like to display 3 colums on a report. Sender, receiver, and product. We have 3 tables to describe this: Party, Product and PartyProductRshp. PartyProductRshp has 2 relationship types described in it: Sender and Receiver. A simple version of the tables is:

Party
partycode
partyname

Product
productcode
productname

PartyProductRshp
ProductCode
PartyCode
PartyProductRshpTypeCd {1="sender", 2="receiver"}

I would like the three report columns to appear as follows:

Sender | Product | Receiver
Fred Bananas Bert
James Apples Jim
etc...

Is someone able to tell me how I can define a column based on the relationshiptype in the PartyProductRshp table?

Remember, I'm new to CR so please be gentle.

Thank you,

Paul.

 

[lbass]

Use the PartyProductRship table as your starting table and then link the other two tables to it. If you are willing to change the column order, I think you could simply insert a crosstab that uses PartyProductRshpTypeCd as the column field, and partycode and product as the row fields. Then insert a maximum on the {Party.PartyName} field as the summary. Place the crosstab in the report header or report footer.

-LB