Insert * to a variable in request page report with table relation G/L Account

vantonenas

Hi experts. I have an issue at the reports. I am using NAV 2015. I have created a report. At the request page i created a variable and insert at the properties the table relation to G/L Account.

My issue is that i cannot use the (*) eg. 12-00* in this field. At the original field of the GL Account section i can. I need the same for the request page.

Any help please.

Kishorm

Instead of using the TableRelation property you can code the lookup in the OnLookup() trigger of the field. You can leave the OnValidate() trigger empty so that the field will accept any value including filter expressions.

To see an example of how to code in the OnLookup() trigger you can look at the SalesCode field on report 715 "Price List"

vantonenas

Thank you Kishorm for your reply. I know about the look up trigger. My issue is that in the original field when you type the G/L Account the list appears automatically. On the look up trigger this does not happens, you have to press F4, open the dialog e.t.c.

Please see the image below.

Kishorm

Unfortunately I don't think you have any other option available. Ideally you would need a ValidateTableRelation property that you can set like you can on table fields but this is not available.

vantonenas

I believe the same like you. I had a hope if there is something else. I will investigate further and i will come back.