How to have three prompts with one object?
I am creating a report where I want to see an employees salary in three different periods, f.ex 11.2006, 08.2007 and 09.2007. This is no problem when I set these spesific periods as filters in the query. But how can these three periods be prompted values? So that the user can choose for which three periods he wants to see the salary?
I have used an object Month Year to try. I drag it into the filter area of the query three times, and gives it prompt-functionality and call them Date 1, Date 2, Date 3. When I try to run the query it just tells me "No data".. (BO 6.0)
Is this possible?
Will sign points if you can help!
Jacques du Preez replied
The in list actually allows you enter as many dates as you like.... but since you only want 3 then you would need 3 prompts using the "OR" between them.
Once you have entered the 3 dates in your case, on the report you can then do a comparison by making a cross-tab with the dates as the headers.