put in an input box a value an use like list box

[#1]

Hi dear experts,

could we put a value in a input box and present like a list of values and use like a filter?

a mean if a set a variable with a field values then use that variable like list for filter in the report.

best regards.

[Anonymous]

Hi Roldan

It is possible to create a drop down list in a input box but I don't know of anyway to use it as a filter .  I would just create a field in the script with an inline table and use that.

[#3]

Hi Bella,

thanks for answer, well the reason is because in the input box with drop down list we only select one value at time and in ohter option , it is to much problems  because the report it has to many conditions.

so I made the drop down list but I dont know jet how can set the value of the field with this variable,

tried with a trigger but when I select the drop down list value it not filter the report.

any idea?

best regards.

[giakoum]

You can use set analysis to use the variable as a filter in your expressions :

For example :

sum({<Month=["$(Variable1)"]>} Sales)

[#5]

Thanks Ioannis,

where I can configure that part?

best regards.

[giakoum]

not sure what you mean.

This is an expression within the chart.

And the variable I guess you know how to setup since you already have the drop down.

Please elaborate.

[#7]

thanks Ioannis ,

I see where

but for example in this example(attached file) it Works  I mean the value apear but is not selected.

there's any way to select in the same time of the variable is seting?

regards