How to dynamically change the column from which the prompt is made?
835787Jun 1 2012 — edited Jun 4 2012Hi,
I have a requirement where in i dynamically want to change the column on which the prompt is made. Say my prompt is made on col1 i want it to dynamically change to col2. To achieve this i made two prompts in the first prompt i gave choices of columns say col1 and col2. Once the user selects any of the one columns it sets a presentation variable. The second prompt i made in column mapping i gave the presentation variable name. This should have done the trick as per my understanding.
However, the second prompt is not able to pick the value from the presentation variable on this. Any thoughts on this or is there an alternative way to achieve this.
Thx
RJ