date wise report by using oracle form?

[fazalmast]

hi to all Experties.
guide me please can we display report datewise in oracle form 10G?
actually i want to query date wise because in our company we are printing monthly reports and i made two text items one for start date and one for end date i want when i give date its display all records in report between that date.how it will be possible plz give me clue and plz help me.

thanks in advance

[amitpatel66]

you will need to write a button click trigger and use the date values in that trigger to fetch the data between those date values

[vsct]

you will need to write a button click trigger and use the date values in that trigger to fetch the data between those date values

[gaurishere]

write query which will fetch the data from table by passing date as parameter on button click
eg select column from table_name from date_column between &fstart_date and &end_date
add order by if u want to display in order manner