Home » Developer & Programmer » Application Express & MOD_PLSQL » Passing Values From One page to other (Apex 4.2, windows7)
Passing Values From One page to other [message #598017] Wed, 09 October 2013 14:25 Go to next message
Messages: 12
Registered: May 2013
Junior Member
my Doubt was
report 1- I created a report using department table
and I had given an new number field
and Button(which call to second report)
number field(department number) should take as a parameter for second report
report 2- I created a report using employee table (select * from emp where deptno = :p1_field)

but I was getting error "No data found."
please give solution

Thanks in Advance

Re: Passing Values From One page to other [message #598023 is a reply to message #598017] Wed, 09 October 2013 15:45 Go to previous message
Messages: 20446
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What kind of a report (report 1) is it? Interactive or classic?

The simplest way to do that is to use built-in Apex feature that allows you to call another page within the same application, so you simply click DEPTNO you want and Apex does the rest. Of course, report 2 page has to contain a text item which will hold report 1's DEPTNO value.

Message you got suggests that :P1_FIELD remained empty.
Previous Topic: PDF Printing with FOP/Apache Tomcat/J4LFOPServer in windows
Next Topic: Date picker
Goto Forum:

Current Time: Fri Oct 09 22:49:40 CDT 2015

Total time taken to generate the page: 0.04679 seconds