Small and medium business | Business Central, N...

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

(0) Share

Report

Posted on by DineshM

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)

All responses (4)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

show me your code.

Thanks.

Was this reply helpful? Yes No
DineshM 238 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Amit 2,559 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (0)

Report

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/

Thanks.

ZHU

Was this reply helpful? Yes No