I am new to Impromptu and not sure of its features. I have below requirement in my existing report.
There is a list report which has two date prompts : From_Date and To_Date and one Value Prompt(say P1)
P1 has four different values viz., A,B,C,D for example. Now when the user selects either 'A' Or 'B' in the prompt P1 then the filter on the date prompt shld use column say Travel_Date. But if user selects either 'C' or 'D' in the prompt P1 then the filter on the date prompt shld use column say Departure_Date.
So I would dynamically change the where clause of report query. I know we can do this easily in cognos 8.x/10.x but i m stuck up while implementing this in impromptu.
Suggestions wld be appreciated.
Thanx in advance.