How to Hide rows in a Listbox

[#1]

Hi All,

How do i hide rows that i wont use from the Listbox.

Sample Listbox:

Code
05
06
07
08
09
10
11
12
13
14

so i only want to use 05 and exclude all other numbers excluding Selection and Reduce data

can't i exclude from load script?

Regards.

[Anonymous · Accepted solution]

i hope i understand your questions.

You can just use the condition in the load statement to restric this field with a where clause like..

...

From SomeTableName

Where Code = 5;

Note that this approach will reduce the data for the entire table and not just for the field.

Hope that helps.

[sagarkharpude]

Write below condition in list box expression

=if(Code=05,05)

[#4]

Hi Paulos,

This may help to you

ListBox Properties-->General Tab--> Field--> in the field drop down menu select 'Expression' and then write expression as

if(Code=05,Code,NULL())

Regards

Harsha Nandan

[#5]

Hi Guys,

i used the method in the load script as of

where Code=04;

it works.