Customized Dynamic Cascade prompting

[pko123]

Hi,
I have report in which there are 4 fields.

1) Event
2) alarms
3) start date
4) end date

now each event has one start date and one end date and each alarm has one date.
for example

Event      start date            enddate
1           7/2/07                7/22/07
2           8/2/07                8/22/07


alarm       date       
a1          7/5
a2          7/10
a3          7/15
a4          7/20
a5          7/25

now i want to create a report with there parameters
1) event
2) startdate
3) enddate
i want to pull all the alarms that happened between entered startdate and enddate dates and i also want to show default values of these 2 parameters as startdate and enddate for that event.
i tried using dynamic cascade prompting but problem is you have to select that date you can't edit LOV's.

can anybody suggestion anything else to this problem?

Thanks

 

[pko123]

any help on this?

 

[Turkbear]

Hi,
If you include the parameters themselves ( {?startdate} and {?enddate} ) in the report whatever values are chosen for the parameters will be in those fields.
To Use those be sure that in your Selection Formula you have

{date} in {?startdate} to {?enddate}

If you are allowing multiple discrete values for those parameters then special steps are needed to show them in the report..See this excellent FAQ:
faq767-5684





To Paraphrase:"The Help you get is proportional to the Help you give.."