How can I add lookup to a report field?

sjen

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?

kylehardin

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.