Have an interesting question.
Lets say my report has a prompt on Zone - This is my prompt syntax.
TableA.ZONE IN @Prompt('Enter Zone or type All', 'A', '(ClassA\Zone)', MULTI ,FREE)
Now my SQL in WEBI would be showing this prompt syntax in WHERE condition.
But what would happen once I choose a Zone at runtime, or once I enter All, where can I see the new sql that hits the database. I feel this should definitely be stored in some place - the sql with the prompt answer.
Can anyone think of an answer to this question - I will really appreciate it if you can give me any leads.