Hi Friends
have any one worked in cascading prompts…Does Bo have this property
ex: you have three prompts
Current month
Previous month
Previous 2 month
If you enter Current month the other two prompts should automatically take the Previous month and Previous 2 month
Thanks
K.Murali krishnan
kmk (BOB member since 2005-05-27)
Hi,
cascading prompts are prompts where the values displayed in prompt two, are dependend on the value entered in prompt one.
ie: the first prompt shows country, the second prompt shows only the values for the choosen country.
You are talking about using a prompt value in multiple WHERE clauses. Since you’re asking it in Reporter, you will have to create the first prompt and select ‘show list of prompts’ for any following clause. Since you’re asking about previous (2) month, you will have to create a construction in which you substract one/two months from the input given in the prompt.
Regards,
Gerard
highandstoned 
(BOB member since 2005-08-01)
Hi,
Cascading prompts work the other way as explained by highandstoned. In your case, you can create a prompt object in the universe that prompts for the current month. At the same time, you can create 1 or 2 more objects that subtracts first and second months using a function similar to AddMonths in Oracle and then drag the date object to compare with the created objects in the conditions pane something like
HTH.
Regards,
Suresh
chvsuresh (BOB member since 2005-03-25)
Hi Gerard
Is the cascading you have said is possible in BO
If yes can you pls give me the steps
Thanks
K.Murali krishnan
kmk (BOB member since 2005-05-27)
A) Cascading prompts are a feature of Crystal Reports.
B) A work around exists for Business Objects, please look in FAQ Designer.
Andreas 
(BOB member since 2002-06-20)
Hi,
a search would have revealed:
https://bobj-board.org/t/15227/8
It’s only possible in designer!
Regards,
Gerard
highandstoned (BOB member since 2005-08-01)