I am working and requirement is to save and print record using jasper report. I used a plsql block in process and when submitt call a jasper report... the problem is on save button first call report and then perform insertion. I need to run first plsql process and then call jasper report using Javascript.
apexgeek
To achieve the requirement where you need to first save the record (execute a PL/SQL block) and then call a Jasper report with parameters in Oracle APEX, you can follow these steps:
Here's an outline of how you might implement this:
Step 1: Create PL/SQL Process
Make sure to replace
:PXX_NEW_RECORD_ID
with the name of the page item you've created to hold the new record identifier.Step 2: Create Page or Application Item
Create a new page or application item to store the identifier. For example,
PXX_NEW_RECORD_ID
.Step 3: Create Dynamic Action
Step 4: JavaScript Code
In the dynamic action's JavaScript code, you would have something similar to the following:
Ensure you replace
http://your-jasper-server/report
with the actual URL to your Jasper report,_format=pdf
with the desired report format, andparam1
with the name of the report parameter that will receive the identifier.Additional Notes
With the above steps, when you click the Save button, it should submit the page, causing the PL/SQL block to execute, insert the record, and then the Jasper report will be opened with the newly created record ID as a parameter.
Mirza suleman
Thanks sir its working now.... i need to hide URL of jasper reports parameters