OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Passing Values From One page to other

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Passing Values From One page to other (Apex 4.2, windows7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Passing Values From One page to other [message #598017]

Wed, 09 October 2013 14:25

lakshman0145
Messages: 12
Registered: May 2013
Location: HYDERABAD

Junior Member

Hi,
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

Report message to a moderator

Re: Passing Values From One page to other [message #598023 is a reply to message #598017]

Wed, 09 October 2013 15:45

Littlefoot
Messages: 21826
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.

Report message to a moderator

Previous Topic:	PDF Printing with FOP/Apache Tomcat/J4LFOPServer in windows
Next Topic:	Date picker

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 23 13:28:19 CDT 2026