BusinessObjects Board

How to give the sequence in cascading Prompt?

building reports webintelligence
#1

I have created cascading LOV in Island reort marketing universe for Year–>Quater–>Month.
After that i have created 1 web Intelligence report by using Island Resort Marketing Universe which contains Year,Quater,Month in “Result Object” Panel while in the “Query Filter” Panel i have taken Month Feild and created the prompt. After that i run the report and save it in a particular folder.

Then whenever i opened the report in Infoview i am getting the prompts in following sequence:
Enter Value For Month
Enter Value For Quater
Enter Value For Year

I require prompts in following sequence:
Enter Value For Year
Enter Value For Quater
Enter Value For Month

Can anybody tell me how to sort the Cascading prompt sequence ?

Thanks

saifkhancs35 (BOB member since 2010-04-28)

#2

Hi saifkhan,

In the report, go to Edit Query mode, Go to Properties tab.

There you can find the prompt order. set the order run and save the report.

Regards,
Pradeep.

av_deepu :india: (BOB member since 2010-08-11)

#3

Hi Pradeep,

In Properties Tab i am getting only one prompt which is related to month. While running the report i am getting 3 prompts beacause i have created the cascading LOV’s.

regards,
Saif

saifkhancs35 (BOB member since 2010-04-28)

#4

Hi,

Go thru this to get your answer…

Remember, try Searching befor posting…

Cheers!!

nitin_gons :india: (BOB member since 2009-05-26)

#5

The above link is not providing the clear view on this problem. Can anybody just suggest whether sorting of cascading LOV’s in WebI is possible or not?

saifkhancs35 (BOB member since 2010-04-28)

#6

Did you tried to insert the sequence numbers infront of the Prompt text?
like
1.Enter Value For Year
2.Enter Value For Quater
3.Enter Value For Month

Regards,
Pradeep.

av_deepu :india: (BOB member since 2010-08-11)

#7

Yes Pradeep, I have already tried that option, but still it is not working

saifkhancs35 (BOB member since 2010-04-28)