Submit Apex report parameters (part 4 of 5)

By WimPosted on April 2, 2019November 21, 2019Cat APEX Application Express, Oracle Report Server

Demo: https://apex.oracle.com/pls/apex/f?p=80981:3 What should happen during submit? get the item values on the page and its data attributes and compose a JSON stringpass the JSON string to the databasein the database procedure, convert the JSON parameter and compose an URL for the Report Server. Validate values, for example when the Destination Type = FILE, the… Read More »

Open report page (part 5 of 5)

By WimPosted on April 2, 2019November 21, 2019Cat APEX Application Express, Oracle Report Server

Demo: https://apex.oracle.com/pls/apex/f?p=80981:3 After posting the SOAP message to the database, we are waiting for the response. The response from the Report Server is wrapped as a <![CDATA[result]]> tag in the SOAP response. If the report has run successfully, this may be an example of the output: <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <SOAP-ENV:Body> <ns1:runJobResponse SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="urn:oracle-reports-rwclient-RWWebService"> <return… Read More »

Apex interacts with Oracle Reports Server (part 2 of 5)

By WimPosted on April 1, 2019November 21, 2019Cat APEX Application Express

Demo: https://apex.oracle.com/pls/apex/f?p=80981:3 The user interaction of the generic Report submission form is very simple: the user chooses the report he wish to runhe fills in the (optional) parameter settings or selection criteriahe presses the [Submit] buttonhe waits for responsethe report output is opened and displayed in a new window. The actions are represented in following… Read More »

Rendering Apex generic Report Form (part 3 of 5)

By WimPosted on April 1, 2019November 21, 2019Cat APEX Application Express, Oracle Report Server

Demo: https://apex.oracle.com/pls/apex/f?p=80981:3 The old stuff First step is to refresh your memory and have a glance at the (good) old Forms interface. I even have a screen print of a client/server environment (6i) which still works under a VM / Windows XP: In Oracle Forms the generic Headstart Report Launch Form looks like this: The… Read More »

How to build QMS0012F in Apex and integrate with Oracle Reports Server (part 1 of 5)

By WimPosted on March 28, 2019November 21, 2019Cat APEX Application Express

Demo: https://apex.oracle.com/pls/apex/f?p=80981:3 For those of you who are in a long term migration of Forms applications to the Apex platform, this article might be of interest. Especially for developers who relied on Headstart Designer, which was a productivity booster for Oracle Designer, made by the Dutch Oracle Consultancy department.Part of the Headstart tool was the… Read More »

Apex Free text search

By WimPosted on March 24, 2019May 21, 2020Cat APEX Application Express

I used to write my free text search SQL in Apex Standard Reports or as a Pre-Filter for Interactive Reports or -Grids like this, based on a single text field :P1_SEARCH Demo see: https://apex.oracle.com/pls/apex/f?p=80981:2 select emp.empno, emp.ename, emp.job, mgr.ename manager, to_char(emp.hiredate,'YYYYMMDD') hiredate, emp.sal salary, emp.comm commision, dep.dname departmentfrom empjoin dept dep on dep.deptno = emp.deptnoleft… Read More »