Current Position:Home > Oracle Report in New window with submit

Oracle Report in New window with submit

Update:10-11Source: network consolidation
Advertisement
Hello, I'm in urgent need of an example on how submit a page and open a Oracle Report in a new window. I've searched the forum and found similiar threads, but not exactly what I need. Basically, I have an html page with cascading LOVs in which the user can cascade down until they get to the report (oracle report) they will like to generate. I'm using Patrick's ApexLib for my cascading LOVs. The user can also pick a date range via a Date Picker. I need the page to submit so that paramters from the LOVs and Date Picker can be passed to the Oracle Report. The Oracle Report needs to open in a new window. Currently I'm using a button item using a branch which runs the report fine, but it comes up in the same page. Can someone point me in the right direction as to how to accomplish this? Thanks in advance for your help!
Lou

The Best Answer

Advertisement
Hi Lou,
you don't have to submit the page. If you have all the values on your page in HTML input fields you are fine. You would only submit it if you want to do some additional processing on the server to calculate values, ...
So just create a button with "Redirect URL without submitting page",
set "Target is a" to "URL" and use the following code in the "URL Target" property.
javascript:popupURL('http://your_oracle_report_url/regionid='+$x('P4_REGION_ID').value+'city='+$x('P4_CITY').value);The $x('some_page_item').value is used in JavaScript to reference the current value of an HTML field. Use the same identifier as you have used for your item in APEX.
Hope that helps
Patrick
My APEX Blog: http://inside-apex.blogspot.com
The ApexLib Framework: http://apexlib.sourceforge.net
The APEX Builder Plugin: http://sourceforge.net/projects/apexplugin/
  • Oracle Report in New window with submit Update:10-11

    Hello, I'm in urgent need of an example on how submit a page and open a Oracle Report in a new window. I've searched the forum and found similiar threads, but not exactly what I need. Basically, I have an html page with cascading LOVs in which the us

  • Starting Oracle Reports 11g in Windows 7 Update:11-30

    Hi there, Does anyone have any luck running Oracle Reports 11g in Windows 7? I installed WLS server (10.3.2) successfully. I installed OFM (11.1.1.2) successfully. Started Oracle Forms 11g successfully. Able to connect to Oracle database and created

  • Open oracle report in new window from method Update:10-11

    Hi, I have a requirement to do some stuff in the view object, save changes, launch an oracle report 10g in a new window, and then navigate to a new page on a SINGLE button press. I can get all this done using a command button to call may backing bean

  • Display Oracle Report on new window Update:10-11

    Hi, How can I display Oracle report from HTML DB on a new browser window? I have branch to this report. Thanks much for your help. LakshmiSearch this forum for "new window". You should find it. Try: checkbox and report page in new windowRead oth

  • How to run Oracle Report in new window Update:10-11

    Hi, There appear to be many threads regarding this issue, but so far I've been unable to piece together a solution to my problem. My requirements are quite simple really. - Invoke an Oracle Report from an HTMLDB page - Pass parameters form the page t

  • Error when open Oracle Report Builder 10g (Windows 7 Ultimate 32-bit) Update:10-11

    Hi all, I installed Oracle Developer 10g on windows 7 ultimate 32bit. Form builder running well, but the report got problem when i opened. This is the error message: Problem signature: Problem Event Name: APPCRASH Application Name: rwbuilder.exe Appl

  • Oracle reports 10 in windows 7 will not open. Update:10-11

    I just installed Oracle reports 10 on a windows 7 pc. It open once. I updated my tnsnames with the following # tnsnames.ora Network Configuration File: C:\DevSuiteHome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. EXTPROC_CO

  • Opening an Oracle report in another window Update:11-30

    I am calling Oracle Reports from HTMLDB, the report is called from a button press with a branch to a URL, a substitution string has been set up and single sign on is being used. The url is: &REPORTS_URL.module=&P2_REPORT_ID..rdf&ssoconn=devpmd

  • How to install oracle report builder in windows 7 Update:10-11

    Hi Team, Could you guide me to install oracle report 11g in my PC . Previously i was using 10g . OS : win 7 DATABASE : 11gFollow How to install forms builder? | Oracle Community Hope read all and give a try. HamidRead other 2 answers

  • DB2 OS400 Connection with Oracle Reports 9i with Windows XP Update:11-30

    Dear Friends I have a valid ODBC connection of DB2 OS400 and i am using the same with Crystal Report i want to use the same connection with oracle Reports 9i & Forms 9i. The response will be highly appriciated. Rgds Muhammad Tahir Khanduplicate post.