I am working with Crystal Report XI Release 2. I created a report which is using a SP (Oracle DB) and this SP have a single input of Date type. I need to have one more input with dynamic values to filter some records. For this purpose I written a command query giving me all possible dynamic values and I created a dynamic input.
So now I was having two input - One from SP of Date type and other one having dynamic values coming from command query.
I saved this report and tried to run it. It prompts me for Date input. I selected a date, again it prompts me with two input, Date and Dynamic input.This time date was same as per the last selection.
Please help me out so that it should prompt me only once.
Thanks in advance.