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
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.