Howe to use "UserResponse" 2

[13153]

In my report i have a condition " Arrival code In List 'ORD;CLF;DFW'"
I like to show the arrival code's that are in the list in my report. I created a cell with the formula "=UserResponse("Bestemmingen","Arrival code In List").

Bestemmingen is my data_provider

I only get a empty cell.

 

[xlbo]

UserResponse takes the user's response to a prompt - you seem to have a pre-defined list...no user interaction so no result in the formula...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[blom0344]

Just an idea:

There is a function that allows you to print the SQL statement (from the dataprovider) in a cell.
By using POS and SUBSTR functions you can then manipulate the string to show the bit of the SQL that contains the condition you want to show...

Ties Blom