Getting all contact person names through XL Reporter

[Former Member]

Hi All,

I am trying to get a list of all contact persons associated with a business partner.

I am having difficulty to pull all contact persons associated with a business partner. I am trying to get this information through the Report composer of XL Reporter.

When I drop the Business Partner and Contact Person dimensions from Business Partner tab into Report Composer and run the report, I only get Business Partner and just one contact person(the first contact person created for that BP).

I am trying to get all contact persons associated with that business partner. Is there something I am missing or is this the issue with XL Reporter.

Please let me know. Than you for your input.

Regards,

Payal

[Former Member]

A good tip about using XLR is that you should try using the Report Composer and once the report is working then "convert" to the XLR report. I also found that using XLR for "simple" things does not seem to work.

Good luck

Robert

[Former Member]

Hi Robert,

Thank you very much for your input. I tried to build this report in Report composer. But it does not give me the right results.

Thanks,

Payal

[Former Member]

I am afraid XLR is not a proper tool for your task. An SQL query will be easy to handle this report.

Try a simple query like Select * from DBO.OCPR WHERE CardCode = '[%0\]'

Then check which fields you need.

Thanks,

Gordon

[Former Member]

Hi Gordon,

Thank you very much. Yes, I know a query will work.

But, the customer is more inclined to get this information via XL Reporter. I just wanted to check if it is possible to achieve via XL Reporter and that I am missing anything.

Thank you,

Payal