system
#1
Hi ,
i have an 3 prompts one is year and month and day
can u please explain nested prompts
how to use 3 prompts i have combain the prompts…
year 2007:nov and dec (it fetch the month in db level)
month nov and dec ( days)
plz any one explaint how to use nested prompts( i have 3 prompts)
cheers
nsai
nsai (BOB member since 2007-03-27)
system
#2
Hi,
Have a look at the 5th entry in Designer FAQ.
Marek Chladny (BOB member since 2003-11-27)
system
#3
Go to Tools > Lists of Values > Create Cascading Lists of values
Choose from the highest level of hierarchy to the lowest one. Say, Choose Year first, then Month and so on…
When you prompt for the lowest level of hierarchy (Say Day) in your report query, it will automatically display the higher levels as a tree structure.
nithya_raj (BOB member since 2007-02-03)