Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interactive report with date picker

paul patakiJun 17 2024

Hello,

Hoping you well today.

I am new to apex .I need to create one report that is using date picker to limit the output of the report based on date range.

I managed to install and configure Apex and ORDS.I am using apex 23.1 .I have create report that uses sql query.I have create date picker for eg. P2_FROM and P2_TO.

In my report query I used :P2_FROM and :P2_TO in the where clause.I also have a submit button. When I hit submit, my report is not displaying .Please assist me ,where did I get it wrong .It seems no action is done ,the values for the Date picker are not passed to the report.

If possible please send me step by step on Oracle apex 23.1 .I will be happy to be able to produce this first report. I will be able to do other reports.

I am looking forward for your assistance.

Kind Regards,

Paul

Comments
Post Details
Added on Jun 17 2024
1 comment
833 views