order of the cascading prompts

[system]

hi

i have a casading prompt. please see the attachment for the screen shots.

After selecting the value from the below prompt only i am able to select the value in top prompt.

Can we reverse the order and get like the below one.

Select the Report Period
Select the From date
cascading prompts order.doc (54.0 KB)

---

breeze_08 (BOB member since 2008-04-03)

[system]

Have you defined the hierarchy of the prompts in Designer? if so what sequence you define them?

---

murali_Lagisetty (BOB member since 2008-09-29)

[system]

Hi,

Please find the code i have written to implement the cascading.
i have two ojects namely

1. Current Year-> Which displays only the current year dates
2. All Year-> which displays all the dates for all the years

Then i have an object “Report Period” with following code

CASE WHEN @Prompt(‘Select the Report Period’,‘A’,{‘NAM Fiscal Calendar’,‘Custom Time Period’},mono,constrained) = ‘NAM Fiscal Calendar’ THEN @Select(Cascading\Current Year)
WHEN @Prompt(‘Select the Report Period’,‘A’,{‘NAM Fiscal Calendar’,‘Custom Time Period’},mono,free)=‘Custom Time Period’ THEN @Select(Cascading\All Year) END

In the “From Date” object i am calling the “Report Period” object (defined above) as

to_date(@prompt(‘Select the From Date’,‘D’,‘Cascading\Report Period’,mono,Constrained))

in the report query panel i am dragging “From Date” object and i am getting the prompts as shown in the attached screen shot (in Previous Post)

But i want to reverse the order of the Prompts?
How to achieve it…

If any other information is needed please let me know.

---

breeze_08 (BOB member since 2008-04-03)