Report Request Page Filter Multi Value Selection

(1) Share

Report

Posted on by One And Only Naveen

138

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

All responses (2)

Answers (1)

Verified answer

One And Only Naveen 138 on at

Like (3)

Report

Report Request Page Filter Multi Value Selection

@Ramiz Thanks for suggetion ,

Below method worked.

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

Like (0)

Report
Report Request Page Filter Multi Value Selection

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;