Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Allow range fields on ...
Microsoft Dynamics NAV (Archived)

Allow range fields on request page of my reports

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I want to accomplish the following behaviour, allow the end user to enter filters on ranges the same way NAV allows. I have added some pictures to illustrate what I'm saying.

ss-_2D00_-new.png

ss-_2D00_-new-2.png

So far I have been able to relation my field (which is a text type) to the table "Vendor". But it only let me select one value if I try to mirror the behaviour above, the second value replaces the first one I picked.

ss-_2D00_-3.png

ss-_2D00_-4.png

ss-_2D00_-5.png

Any suggestions will be appreciated. I have search everyone but haven't able to find something.

*This post is locked for comments

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Allow range fields on request page of my reports

    Open the page in designer mode and one of the field is Glaccount.. Press f9 to get into the code and you will see the code on the lookup of that field how it was implemented.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Allow range fields on request page of my reports

    I haven't work with pages too much, could you please tell how to do that? I mean where to go once im inside the page design.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Allow range fields on request page of my reports

    It is not possible with table relation property, you need to write your code on the Lookup of the field and execute the logic.

    For example lookup at page 113 Budget, where the G/L Account filter has the option to select multiple values.

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: Allow range fields on request page of my reports

    Quick suggestion is: check whether you can add Vendor No. field in ReqFilterFields of data item and not as an option in request page.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans