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.
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().
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
45
Share
Report
All responses (
Answers (
