Report Request Filter help

harold
harold Member Posts: 8
edited 2007-06-25 in Navision Attain
On the report I have a section based on the Product Group Code table. In the report request form I have added the filter field for Code, problem is that there is no lookup button to easily select the value.

In the same report another section is based on the Item Category Code table, the corresponding request filter tab (using Code field) does have the lookup button.

How can I get the lookup button to appear?

Thanks,
Harold

Comments

  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    The difference between the two tables is that the Product Group table has multiple fields in the primary key (Item Category Code,Code), and the Item Category has only one field in the key (Code).

    If you want a lookup button, you have to add code to the lookup-trigger on the request form.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • gianus
    gianus Member Posts: 22
    Luc Van Dyck wrote:
    If you want a lookup button, you have to add code to the lookup-trigger on the request form.

    ..but I don't see the lookup-trigger in the request form. I don't see it neither in the filters tab nor in the custom tab...
    Gianni Capra
    www.exe.it
  • matttrax
    matttrax Member Posts: 2,309
    The onLookup trigger is on the text box, not the form.
    Matt Traxinger - ArcherPoint
  • gianus
    gianus Member Posts: 22
    Hi Mattrax.
    This is the way I solved my problem: putting a text box in the request form and set the onlookup trigger.
    But, this was not my question..(nor Harold's).
    We wanted to know how lookup a table (with more than one pr.key) in the request-form raised by the ReqFilterFields property in the dataitem properties of a report.
    Anyway I solved as I said, and anyway thanks a lot for your answer.
    Gianni Capra
    www.exe.it

Categories