I'm trying to use page item as bind variable in my Report Query. I have checked Session State checkbox and also added my page items in the SESSION STATE ITEM LIST.
but NO RECORD GETTING DISPLAYED IN THE REPORT AT THE RUN TIME.
to see it live please login to
I have tested the query in the Source Query testing area which is similar to SQL Command Window and its work fine their. for this testing i perform the following steps.
you can also perform this by logging into my workspace
Action is Redirect to URL.
URL is f?p=&APP_ID.:0:&SESSION.:PRINT_REPORT=MyReportQuery
select EMP.EMPNO as EMPNO, EMP.ENAME as ENAME, EMP.JOB as JOB, EMP.MGR as MGR,EMP.HIREDATE as HIREDATE
from EMP EMP
WHERE EMPNO =:P2_X_PARAMETER
P2_X_PARAMETER is the number field on my Report Page.
you can also see the query by logging into my workspace
Sorry i did not provide the workspace name. for developer access my workspace name is kashif0777, username firstname.lastname@example.org, password is 123456. i try to set Action When Button Clicked to Submit Page and set the buttton request field to the URL of the Report Query but it did not work. can you please explain or make changes in the application.
Thanks Kofi for the help. If you please perform these steps for me i will be very grateful to you. I have never created branches and i dont know what to set in the Action When Button Clicked area of the button properties. I will study Branches tomorrow in office.
what i want is when button pressed