Dynamic and compressed filter selection

[nareshthavidishetty]

Hi,

Am having a list box as below,

A

A,1,2,r,y,……

A,6,s,7,d,…..

B

B,e,46y,5,d,h,….

B,e,3,S,7,10,…..

Actually my list box looks like this, but here my requirement  is my listbox should contains only two values as ,

A

B

Here if I select category ‘A’ means it should show what all the filters start with ‘A’ should come in report but my filter should contains only

'A'&'B'

Thanks..

[MarcoWedel]

Use this expression in the listbox field selection:

=Left(category,1)

Regards

Marco

[arulsettu]

may be like this in list box expression

=if(WildMatch(yourfield,'*A*'),'A',

if(WildMatch(yourfield,'*B*'),'B',))

or this

=SubField(yourfield,',',1)

[avinashelite · Accepted solution]

try like the below expression in the list box

subfield(filedname,',',1)