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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Report Request Page Fi...
Small and medium business | Business Central, N...
Answered

Report Request Page Filter Multi Value Selection

(1) ShareShare
ReportReport
Posted on by One And Only Naveen 458
Hello Mentor's,
 
In my report i have three Lookup Fields which interact with each other based on parent field Selection (which is first- Select Dimension field - First Screenshot).
 
Now when I am selecting multiple values from Lookup field (Screenshot Two), only last most value is reflected in field.
 
My requirement is to get "|" deliminated values on validate.( example : D01|D02|D03 screenshot two)
 
how can i achieve it please guide.
 
 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Ramiz Profile Picture
    Ramiz 597 on at
    Hi,

    You can check codeunit 46 SelectionFilterManagement or you can create a custom code as well.
      
    DimValuePage.SetTableView(DimensionValue);
DimValuePage.LookupMode(true);
if DimValuePage.RunModal() = Action::LookupOK then begin
	DimValuePage.SetSelectionFilter(DimensionValue);
	if DimensionValue.FindSet() then
	repeat
		if DimFilter <> '' then
			DimFilter += '|' + DimensionValue.Code
		else
			DimFilter := DimensionValue.Code;
	until DimensionValue.Next() = 0;
end;
     
  • Verified answer
    One And Only Naveen Profile Picture
    One And Only Naveen 458 on at
    @Ramiz Thanks for suggetion ,

    ​​​​​​​Below method worked.

     if DimensionValuesPage.RunModal() = ACTION::LookupOK then begin
                                        DimensionValuesPage.GetSelectionFilter();
                                        Dimension_Val_Filter := DimensionValuesPage.GetSelectionFilter();
                                    end;

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,135

#2
YUN ZHU Profile Picture

YUN ZHU 733 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 612

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans