web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Customer No. dropdown on Report Request page need to take mutiple customer from Dropdown

(0) ShareShare
ReportReport
Posted on by 238

Hi all,

I was trying to filter Customer Detail trial balance Report based on multiple customers by clicking on no field on Request page this field has dropdown for customer no but when i select first it will show customer as C0001 then i want add customer from dropdwn with C0002 with C0001 like C0001|C0002|C0003|C0004 but when i select from customer from dropdown it will remain last customer as C0004 all other vanish from no field 

it will take multiple customer but have not able to select from dropdown i have to Remember each customer  name 

can i get all customer from dropdown without Remember and can select from Dropdown

in ms Nav it will allow to do this 

any help from expert apricated thank you

I have the same question (0)
  • Suggested answer
    Nitin Verma Profile Picture
    21,812 Moderator on at

    show me your code.

    Thanks.

  • DineshM Profile Picture
    238 on at

    Hi Sir

    this Report is standard Customer Detail Trial balance Report id Customer - Detail Trial Bal. (104, Report Request)

    Customer Dataitem on Request page having No. filed this field has Drop down I want to select multiple Customer from Drop Down each customer when select need to select from dropdown and look like C 0001|C0002|C0003|C0004 using Dropdown

  • Suggested answer
    Amit Profile Picture
    2,563 on at

    Hi,

    Create One Variable-- CustomerFilter -- Text

    Show in Report Request Page with Table Relation Customer.

    write code

    onpredataitem

    {

    Setfilter("Customer No.",CustomerFilter);

    Regards

    Amit Sharma

    www.erpconsultors.com

  • Suggested answer
    YUN ZHU Profile Picture
    102,499 Super User 2026 Season 1 on at

    Hi, hope the following helps.

    How to get a filter for the selected records on any page (For example, ‘1..3|6’)

    https://yzhums.com/27561/

    pastedimage1670977302630v1.png

    Thanks.

    ZHU

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 658 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 499 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 328 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans