Cross company data access using AOT table method

(0) Share

Report

Posted on by Bibin TV

Hi Team,

I've developed an SSRS report, and inside the DP class, I've wrote the query to fetch data from multiple companies which is working fine other than customer name.

To obtain the customer name, I've used the CustTable method as shown below. Nevertheless, I'm currently facing a problem where it solely retrieves the customer name within my present session (legal entity). I kindly request you to examine the information provided below and offer your valuable guidance. Your assistance is greatly appreciated.

1. Cross company query

2. Fetch customer name by using Table method.

3. Company list

4. The report output displays all details fetched from the cross company, except for the method output(from CustTable), which is currently unavailable.

All responses (1)

Answers (1)

Verified answer

Martin Dráb 230,198 Most Valuable Professional on at

Like (1)

Report

Cross company data access using AOT table method

You indeed don't have a cross-company query for CustTable. Either wrap the call in changeCompany() block or use a crosscompany select statement (as for projTable) instead of calling find().