Application Express :: How To Add Update Process To Printing A Report
Jun 29, 2012
I followed the directions to print a report using this documentation [URL]....where I setup a report query and a report layout and then add the url to a button that when clicked opens up the report in my chosen format. This all work very nicely. However, I need to update the table behind each record that gets printed and I cannot figure out how to couple the print request and an update process in APEX.
I have created a simple page with a tabular form built on a view. The view is on top of a collection that is created when the page is ran. I added a tabular form column validation. I then was going to add a pl/sql process to handle the updates into the db, but before I did that I wanted to delete the ApplyMRU that was created when I first created the tabular form because it does not make sense on my view. When I went to delete the MRU it gave me an error saying "Multi Row Update processes can't be deleted as long as there are validations defined for the tabular form".
I have searched for an answer on this, but so far I have not found much. I am hoping it is something simple that I am missing. I even tried deleting the MRU first and then add the validation, but then it gave me another error about "Tabular form validations require multi-row update processes" I know this was possible in 4.1, but now I am trying it on 4.2
i have a report with a parameter that i would like to print out from an On demand Process.When there is an Ajax Call Return. i want the report to show before printing.Here is an example of the code used
DECLARE l_customerid varchar2(200); BEGIN l_customerid:= wwv_flow.g_x01; select product_id
I am building an application to edit database data through interactive reports. I would like to add a button to open a pdf file of the report, where the user can save or print it. I tried going to Shared Components>Report Queries and then create. I went through the steps but when I get to the end where it says "Test Report" I get this error:
ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified
What can i do to fix this, or is there an easier way to do this?
I am using APEX 4.0.2.00.09
This app will be distributed to other computers if that makes any difference.
I'm using APEX 4.0, and i don't have access to BI Publisher for printing.
That needs to print off customer address labels. I have a pl/sql query that gets the customer name and address and puts it into mailing address format. Ex. Mike Smith 555 Oracle Dr Los Angelas CA 40455
When i try to print from the browser, it prints really bad with the URL, page numbers etc.
These will actually print out on label paper, and they will be cut and used accordingly.
What i tried so far:
Manipulating the print CSS:
This worked slightly in Firefox, but doesn't work at all in Internet Explorer
Tried adding a third party friendly print button to the application. This doesn't work
I would even be ok for these to print to a PDF or RTF format to download then print off, but i don't have BI Publisher.
I'm using APEX 4.2 and trying to export some classic reports to PDF. I followed these directions to install BI Publisher: URL.....Entered these values in the Apex Administration Report Settings section:
Print Server: BI Publisher Print Server Protocol: HTTP Print Server Host Address: URL.... (also tried with localhost and failed) Print Server Port: 9704 Print Server Script: /xmlpserver/convert
Back in my Classic Report, I configured these settings in the Print Attributes tab:
Response Header: Report Settings (also tried with Print Server and failed) Print URL: f?p=&APP_ID.:7:&SESSION.:FLOW_XMLP_OUTPUT_R7671716059006280
I'm getting this error: report error: ORA-20001:
The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified.I have never configured PDF printing this way and am pretty lost.
I am using "Function Returning SQL Query" (as query is dynamic) to draw the bar chart (flash).
I am facing some issues while trying creating a BI report for this chart.
Issue is : In Shared Components -> Report Queries : Its only expecting an SQL Query.
Do we have any ways to define a "Function Returning SQL Query" over here ? Note that, If using a static SQL both charts / BI reports are working fine with out any issues.
I'm attempting to configure printing via the APEX listener and I'm struggling to understand it. I currently use Oracle HTTP server as the web server for APEX. I have installed the APEX listener and configured it. If I connect via the APEX listener, PDFs work correctly. If I connect via the Oracle HTTP server, I get an error with PDFs. Am I required to connect with the APEX listener for PDF printing? I thought I could configure APEX listener for PDF printing on the backend and still connect via Oracle HTTP server. I'm use APEX 4.2.3, APEX Listener 2.0.5, and Oracle DB 11.1.0.7.
I have been learning to create pdf report with Apex 4.2 and BI Publisher 10 which I have been successful with. Now I like to learn how to create pdf reports using FOP thinking of the customers who will not spend money on BI Publisher. I have gone through the documents and procedures described in Java 4 Less.[URL] and [URL]. Configured Apex instance setting accordingly.
For default layout a tabular pdf report is created. I have created an xsl-fo file named Formatted_report.fo on same query and xml file from report query with BI Desktop. But when I try to print a formatted output with Formatted_report.fo report layout it does not work(J4LFOPServer ). but same layout with .rtf template works fine (BI Publisher Print Server).
I have been learning to create pdf report with Apex 4.2 and BI Publisher 10 which I have been successful with. Now I like to learn how to create pdf reports using FOP thinking of the customers who will not spend money on BI Publisher. I have gone through the documents and procedures described in Java 4 Less. [URL] and [URL]. Configured Apex instance setting accordingly.
For default layout a tabular pdf report is created. I have created an xsl-fo file named Formatted_report.fo on same query and xml file from report query with BI Desktop. But when I try to print a formatted output with Formatted_report.fo report layout it does not work(J4LFOPServer ). but same layout with .rtf template works fine (BI Publisher Print Server).
I'm trying to connect a javascript UI control within my page to an APEX Application Process. The control calls the application process via AJAX and appends a variable number of GET / POST parameters to its URL.What is the best way to obtain these parameters from within the PLSQL procedure of the process? Or is there a better way to connect my javascript AJAX control to the Database behind my APEX app?
I'm trying to make changes to a PL/SQL procedure in an application process and no matter what I do in the PL/SQL text (even removing semi-colons and messing up syntax) no changes register when I call the procedure from a page process. I've also tried creating a new application process with a similar procedure of a different name, and no page processes will allow me to call the procedure, saying that it needs to be declared. APEX 4.1.1
Application process (with htp.p in it) does not execute when onSubmit page process returns error (and shows it in notification bar).
How can I make process to execute? Or it is a bug? You can see example in test application Report 1Just press SUBMIT button and see difference near phrase "application process is here" at the top.
so on. id2 is a fk key in this table. for same id2 it may have more than one row. I have process and following is part of it but getting error that is PLS-00224: object 'P30_QUES' must be of type function or array to be used this way .
declare v_count number; v_code number;
begin
select count(*) into vv_count from table1; -- it may have 7 or 8 questions
FOR i IN 1 .. v_count LOOP
select code into v_code from table1 where code = :p30_ques(i);
if :p30_ques(i) is not null then INSERT INTO table2 (id1, id2, attr1, desc) values (null,fk_value, v_code,nvl(:p30_ques(i),null)); end if; commit; end loop; end;
I m trying to call a process on log out URLIn apex4.1 in authentication scheme we have logout url were we change the page were we need to redirect on logout click
But In apex4.2 under authentication scheme Post-Logout URL
I have given url here like this apex_authentication. logoutp_session _id=&SESSION. &p_app_id=&APP_ID.:117 on this page i have the two process but i m getting error System Unavailable.
I used to have a button, that called an after submit page process and everything ran fine.The page had loads of buttons, so I got rid of the buttons and created a list instead.I have an entry in a list. Target Type: Page, Page 1, Request is set to RUN_PLAN.This calls a before header page process with a condition of Request = Exp1 and Exp1 is set to RUN_PLAN. When the user clicks the list item, the process is run. This works fine.I also have a report on this page.As the process runs, it is updating a table.The user needs to watch this process running (via the report), so they need to keep refreshing the page.The problem is, that when they refresh the page via the browser refresh button the process is called again. How can I stop the process from running, every time the user refreshes the page.
I have to create a tabular form, in which I have each row having an address information in it. I need to individually geocode each of these addresses and process it from the page (I have a web service to do the geocoding) .
How can I process each row of a tabular form individually from a page?
I have a page (16) and a tabular form when the user select the check box I update the zero page item
$x('P0_REPORT_REFNO').value=l_value;
this works fine till this point now i have a button will calls page 8 and pass the parameter to page 8 P0_REPORT_REFNO is displaying the selected value but passing null to page 8.I am running the application on apex.oracle.com
Having this issue in Apex 4.1.1 and 4.2 (haven't tried it in versions prior to 4.1.1 yet). So I got my standard IR, and trying to create a private report with control breaks, aggregations.
Once I save it as a private report, It applies the same on my primary report.
It's no big issue as I can flip back to Primary report and delete the control breaks, aggregations but is some kind of bug? Ideally it shouldn't modify my primary report unless I try to save it as "Default Report Setting".
My collection is not working as expected, what could be the issue here. This is what i did,
1. I created a collection in a process to fire on page load
if apex_collection.collection_exists(p_collection_name=>'MMMM') then apex_collection.delete_collection(p_collection_name=>'MMMM'); end if; APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => 'MMMM');
2. On my page i have a text field P1_text1 when i enter value into text field like ="sample data" i want this data loaded into my collection, so i created a button and added a process(on submit - before computations...) so it should insert into the collection when i click the button but no data is loaded, process:
if it is possible to include 'data' files as part of the Application Export process. Up till now I've only been able to include supporting object files which will recreate a table structure but not the data records - I've been creating the latter outside of APEX.
I have a Page containing 3 reports and I was wondering if it is possible to re-execute only one of the these reports using a button or preferably a Select List which allows me to choose which of the 3 reports I wish to 'refresh/re-execute'. I may be totally wrong here but I assumed that choosing the option to submit a Page will cause all regions to refresh i.e. re-execute the SQL queries they are 'based on'.
I have a Report Region with Type SQL Query and Source "SELECT * FROM <table>" where <table> has a primary key from a sequence. Under Report Attributes, I have Report Column "ST_NM" with Show and Sort checked and having a Sort Sequence of "1". I assume this is to set the iniital display sequence but regardless, the report rows display in Primary key order initially.
To try it: [URL]
1) How do I set the initial display sequence to be other than the primary key sequence?
What is the code/javascript/url behind the test report button on report queries component?
We are having DSN problems using the print url given on the report query. The URL works for some of our developers and not for others.
The test report button on the report query appears to work for everyone but I do not know what is behind the "Test Report" button. If I could recreate the test report button on our page this would be GREAT!
I have to implement IR report search functionality (*when ever we click on column header it will display all the values in that particular column , once we click on particular value , the report will filter based on that particular value * ) in classic report .
I have created a classic report in Apex. Have enabled the print PDF link on the report for the business users to download it in a PDF format. Is is possible to put a logo in a downloaded PDF from the report?
We have several prod instances and many applications on each of these... and interactive reports saved by many users.Each prod application have its own ID, distinct from the dev application ID.
Until today I used the apex_application_install inside the first wokspace only, and it works fine, but I need to update applications on every instances. It seems the only way to keep a saved report during an update is to use the same application Id (use the app n°200 to overwrite the n°200).So it means the only available method is : release the dev app on the dev workspace ; export 50 apps from it and import those 50 times, maybe more in the future.
My configuration :Oracle Standard or XEApex 4.1.1OHS
