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
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.
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.
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?
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
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;
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156