Hi all,
Im wondering if I can use cell valeu data in the Where clause of the GetOtherData function.
EG Get Invoice Key where Payment No = whatever is in cell D9.
I keep getting syntax errors.
I'm trying to report accross 2 modules - AR and Banking.
I need to display Invoice data as well as related payment data.
In report composer after making my AR selections, I try to drag and drop data from the Banking module to show payment data related to the Invoices.
The data is not retrieved.
I was wondering if this might be possible using the GetOtherData function in Advanced Report Builder.
Can I show data related to whats in a certain cell in my report?
Thanks for any suggestions.
John O'Brien