Report Request Filter help

harold

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

Luc_VanDyck

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.

gianus

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...

matttrax

The onLookup trigger is on the text box, not the form.

gianus

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.