Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a listbox that contain hundreds of service code,
However in this particular report, I only want the user to choose 20 service code.
It will not be user friendly for the user to select the hundreds of service code when there is only 20 service code that are valid
Therefore my qn is whether is there any way i can filter the listbox?
Thanks
Hi,
The answer is "Yes for Sure". We can limit item in list box. Here is some clue by using expression, something like =Aggr(Only({1<Field = {1,2,3}>} Field) Field)
If you have some sample data that quite easy to figure out.
Regards,
Sokkorn
hi
Check listbox expresion. go through attach file
See sample
[Data]:
LOAD * Inline [
Cliente
1,
2,
3,
4];
Create a list box with expression =Aggr(Only({1<Cliente = {1,2}>} Cliente),Cliente) -> will see only 1 and 2
Regards,
Sokkorn