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

Area selection in report filter via lookup?

(0) Share

Report

Posted on by neckit

144

Hi,

the user would like to select the numbers 10000..20000 (e.g. order numbers) in a report via lookup. To do this, he clicks on the first number in the lookup field; then enters ".." and now wants to select the second number via the lookup field in order to get 10000..20000 as the result. Unfortunately, the field is then simply overwritten with 20000.

Is there a trick here how to prevent "10000.." from being overwritten?

regards Ralf

All responses (3)

Answers (0)

neckit 144 on at

Like (0)

Report

RE: Area selection in report filter via lookup?

Hi ZHU,

I think your solution is not usable in the lookup of a normal report filter field. I can't select multiple records there.

Since the manual input - sometimes with 8-digit numbers - is very error-prone, I have no choice but to add additional fields to all corresponding reports in the request page ("from no." + "to no.") :- (

regards Ralf
Suggested answer

YUN ZHU 73,339 Super User 2024 Season 2 on at

Like (0)

Report

RE: Area selection in report filter via lookup?

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
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Area selection in report filter via lookup?

Yes you can not select other values by lookup, otherwise it will overwrite the earlier value, in that case you have write it manually after .. i.e. firstvalue..secondvalue