Filter in List Box

[#1]

Hi All,

I have a question in report designing, hope anyone can give me a help.

In my raw data, for example, I have 5 years information. So, if I use field: [Year] in a List Box, this List Box will show 5 numbers(eg. 2008, 2009, 2010, 2011, 2012). However, if I only want to show 2 numbers in List Box (2011, 2012), how can I filter this field?

I know it can be done in Script, but I want to know how to achieve it in Properties or other place? Can anyone give me some advices?

Thanks.

J

[#2 · Accepted solution]

hi,

Yes you can do it in list box also.

open the list box properties,in the general tab you will see the drop down of field.

see the drop down list, in that their is an option written as "<Expression>".

Select "<Expression>" and write thr "=If(Year>2010,Year)" or any other expression.

[#3]

Yes, you are right! I cannot believe that I have't noticed this detailed and useful function. Thanks a lot for your help! ^_^