In range filters

[benji41]

Dear all,

I have a detailed filter on my report : [City] in ('Paris','London')

and I have an external BDD table with 2 columns and 2 lines :

column_code      column_name
Europe                  Paris
Europe                  London

So, now, I would like to replace ('Paris','London') by the 2 values on column_name for "Europe" column_code

Is it possible ?

Thanks a lot

[cognostechie]

You can create a prompt so that every time you run the report, it will ask you which values you want. The prompt will be associated to the report query with a filter similar to what you have except that it will refer to the prompt value and not hard coded values like Paris, London'

I would be like this:   column_name in (?pColumn_name?) where  the name inside ?? refers to the prompt name.