Filter in Listbox

[n1ef5ng1]

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

[Sokkorn]

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

[Anonymous · Accepted solution]

hi

   Check listbox expresion.  go through attach file

[Sokkorn]

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