BusinessObjects Board

How to set 2nd prompt value based on the first prompt value

My issue:

I have a date prompt and Version prompt. Based on the date prompt value, it needs to show all the versions available for that date as possible values in the second prompt.
I need both date and Version # to be selected and set in the query.

Any suggestions appreciated.

Thanks!

regards,
ilangovan


ilangovanc (BOB member since 2007-09-23)

Then you should have had a look at cascading prompts in Designer FAQ from here

.


haider :es: (BOB member since 2005-07-18)

Thanks for your response .
I have tried cascading prompt. Though in first prompt i have selected the date, in second prompt, it shows all dates and its versions (hierarchical display).

Is there any way to show only respective versions of the date selected?

or

Is there any way to select both date and version # in a single prompt?

Please advise.

regards,
ilangovan


ilangovanc (BOB member since 2007-09-23)

But you are “ANDing” date and version in the where clause of the generated SQL.
So they have to be in two separate prompts.
What you are asking is to pass the first prompt value(date) to the second prompt(version) in order to show only those versions which belong to the date selected.
This can only be done by prompting again in second prompt for the date passed in first prompt.

.


haider :es: (BOB member since 2005-07-18)