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

vantonenas
vantonenas Member Posts: 10
in NAV Three Tier
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.

Comments

  • Kishorm
    Kishorm Member Posts: 921
    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
    vantonenas Member Posts: 10
    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
    Kishorm Member Posts: 921
    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
    vantonenas Member Posts: 10
    I believe the same like you. I had a hope if there is something else. I will investigate further and i will come back.

Categories