Skip to Content
author's profile photo Former Member
Former Member

XLR-Get Other Data Error

Hi,

I am trying to use the Get other data function in XLR. In the BP Master Data payment terms tab, I have renamed the "ID Number" Field for use as an Insurance Remark field (alphanumeric). I have entered OCRD -OwnerIDNumber as the get other data field. When I generate the report the following error message is returned in the top cell of the expansion: "#ixGetData Error: Invalid use of Null"

Any idea on how to fix this error? Thanks.

Edited by: Philip Eller on May 15, 2008 8:37 AM

Edited by: Philip Eller on May 29, 2008 8:56 AM*

Edited by: Philip Eller on Jun 12, 2008 9:24 AM**

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 23, 2008 at 06:03 AM

    I tested and got the same error but got it to work - try this

    =ixGetData("sa", "aUcfsv2j__", "OCRD", "CardCode, OwnerIDNum", "OwnerIDNum Is Not Null")

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Daan,

      Thank you, but no luck, unfortunately. The OwnerIDNumber column is being propagated with the CustomerCode (does not match CustDescription expansion in corresponding row) and extends further down beyond the range of expanding rows. Any other ideas?

  • author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2008 at 06:21 AM

    Hi

    One would normally use the 'Get Other Data' function to create a lookup column(s) in the report. So it would not be in the expanding rows but separate from your report. You can then use a vlookup to populate a field in the expanding rows. You will need a field in the expanding rows to lookup a value in the data created by the Get other Data function.

    Is this what you are trying to achieve?

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2008 at 06:23 AM

    Hi

    One would normally use the 'Get Other Data' function to create a lookup column(s) in the report. So it would not be in the expanding rows but separate from your report. You can then use a vlookup to populate a field in the expanding rows. You will need a field in the expanding rows to lookup a value in the data created by the Get other Data function.

    Is this what you are trying to achieve?

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.