Prompting for Input twice.

[Former Member]

Hi,

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.

Deepak

[Former Member]

Hi Deepak,

You may choose to modify the SP itself so that the user will be prompted only once.Whenever you run the report the two parameters defined in the SP will form the where condition and bring the updated data directly from the database.