Skip to Content
0
Former Member
May 29, 2008 at 02:00 AM

XLR Get Other Data Function

24 Views

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