Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

How to take value from page

Posted on by Microsoft Employee

Hi experts.

 how to put filter based on my page

USERMAIL (Page) from this i need to get value but im getting first value

USERMAIL.RESET;
Customer.RESET;

Customer.SETRANGE("Customer No.",USERMAIL.No);
IF USERMAIL.FIND THEN
MESSAGE('%1',USERMAIL.No);
Customer.RESET;
Customer.SETFILTER("No.",USERMAIL.No);

based on my form datas i want get filter for reports

Thank you

*This post is locked for comments

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: How to take value from page

    It's really not getting cleared what you want you are trying to do and what's your real target that you want to achieve.

    Can you a level more specific to your question please.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: How to take value from page

    Your query is not clear and not able to understand what are you trying to achieve. If you are planning to get the filter based on your selection of the records on page then you need to use the SETSELECTIONFILTER function of the page.  Look for the usage of that function.

  • Andrey Baludin Profile Picture
    Andrey Baludin 3,941 on at
    RE: How to take value from page

    How report linked to page? It's an action on page which runs a report and you want inside this report get customers list filtered by number from page?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to take value from page

    Hi Andrey ,

    I m trying this in report(no:120) not in my page please tell me how to filter based on by page datas.  i can get the value but only first value only i can get i want to set filter for all record based on customer id.

    Thank you

  • Suggested answer
    Andrey Baludin Profile Picture
    Andrey Baludin 3,941 on at
    RE: How to take value from page

    If you run this code from your USERMAIL page - you needn't use USERMAIL as variable (use Rec or nothing). Also USERMAIL.FIND - set filter on first record.

    Try this:

    MESSAGE('%1',Rec.No);

    Customer.RESET;

    Customer.SETRANGE("Customer No.",Rec.No);

    Customer.FINDFIRST;

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans