How can I add lookup to a report field?

sjensjen Member Posts: 53
I am working on Aged Accounts Payable Report and I want to add a lookup to the Name field just like the other fields have. How can I accomplish this without adding a table relationship?

zlmvrzwi3ses.png

Answers

  • kylehardinkylehardin Member Posts: 257
    RequestFilterFields is a property of the dataelement. The Vendor data element probably started out looking like this:

    RequestFilterFields = "No.", "Global Dimension 1 Filter";

    Just add Name to the end of that.

    But perhaps I am misunderstanding your question. If you already have the field on the request page, but you want it to do a lookup - that's a different matter. You'll have to add custom OnLookup logic to the request page itself.
    Kyle Hardin - ArcherPoint
Sign In or Register to comment.