Hello,
I'm trying to create a custom filter of sorts using date picker page items.
I want a report to have a where clause that says something like this:
WHERE table.Date > :P1_Date1
AND table.Date < :P1_Date2
I need to do it this way because I need to have another region that displays the a weighted average based off of 2 of the columns in that table set and I was unable to find a good way to do a weighted average using the interactive report options.
The issue I'm coming across is I cannot simply reference user interred text from a static sourced page item. I've used radio groups before where on change they had a "refresh and set value" action that allowed me to reference them, but I don't see how to do anything like this with Date Pickers.
Any ideas on how I should go about this?
EDIT:
I've included an example of what I'm trying to accomplish.
Link - https://apex.oracle.com/pls/apex/f?p=30262:101:102700562633003:::::
Username - TESTER
PW - tester