give condition to your report like
where report_date :=Px_report_date(datepicker item name).
Thanks a lot for your help.
Is it possible for you to provide the steps as i get totally confused in between Region / Breadcrumb etc.
1.take one page item as date_picker in which to enter date
as you show above
2. create report on table in which above column r there and give condition to report
e.g select * from Table_name where Report_date := PX_item _name
bredcrumb and region r different one bredcrumb used to show hierarchy only.
What do i enter in
keep default information, only give condition to report
* create a date picker item in the report region (eg : P1_DATE)
* then go to regions in edit page in that select the report region that
you wanna change according to the date value
* go to source tab change the report's query and click apply changes
(eg : select EMP.EMPNO as EMPNO,
EMP.ENAME as ENAME,
EMP.JOB as JOB,
EMP.MGR as MGR,
EMP.HIREDATE as HIREDATE,
EMP.SAL as SAL,
EMP.DEPTNO as DEPTNO
from EMP EMP
where EMP.HIREDATE = :P1_DATE)
* then create a dynamic action
event = change
selection type = Items
Items = P1_DATE
Action = Refresh
Selection type = Region
that's it your good to go now
Grr, nobody has yet pointed out that you should use explicit coversion for dates...
Please dont use:
column_name = :PX_ITEM_NAME
Instead, you should convert the item value to a date based on the format mask that the item is set to, for example:
column_name = TO_DATE(:PX_ITEM_NAME,'DD-MON-YYYY')
no you don't need to convert, it works for me
It's not 'that it works', it's that it is good coding practice. The attitude of 'it works for me' is why there is so much rubbish code out there.