Application Express :: Word Document / Mail Merge With Values From Reports
May 7, 2013
Using apex 4.1.1 , linux , 11gr2
Basically I have requirement to generate a Word doc (letter to a Word mail merge) from a button/navigation link pressed on Apex page which will gather data from the report and fill in values in appropriate place in Word doc.
Is this even possible with Apex with/o BI Publisher
I have Fop installed and tested , PDF works great but excel and RTF is not reading the encoding on attachment download.I am aware of new PDF feature in 4.2.2 but upgrade is just not the scope right now.
I have This Code working on the local form builder after starting the oc4j and run the form. but using OLE2.
but when using the Cleint_ole2 on the application to invoke an object on the client machine.
but nothing happend, while i have tested the webutil configaration and its working fine.
i use this code to print any word document without openning it. and here is the code in when_button_pressed
DECLARE application CLIENT_OLE2.OBJ_TYPE;-- Declare a object OLE args CLIENT_OLE2.LIST_TYPE; -- Declare List of Parameters to obj. OLE begin application := CLIENT_OLE2.CREATE_OBJ('WORD.Basic'); -- Start a process WordBasic args:= CLIENT_OLE2.CREATE_ARGLIST;-- Create a list of Parameters -- Add param. file_name with path(x. c: empmy.doc) :blk01 is my block
I need to generate quotation from Forms 6i. A copy fo the quotation is being uploaded. All information in the word document that are highlighted in yellow are taken from a database.
I need to create the document in the format of the uploaded file. There will be some tables also in the document.
I have a program that uses htmldb_application_files to upload documents to a database. It works fine with .doc documents, but does not work with .docx documents.
Any simple publicly available Restful web service that I can play around with calling from my Apex workspace as a consumer? Something nice and simple (in the spirit of "hello world") such as web service calculator, stock quote, etc..
Also, I was wondering if there is some kind of ability in APEX to import a WADL document, and then APEX can magically create the requests for you?
Is there any official document from Oracle which tells us how to export apex applications from command line instead of using the GUI from within apex ?
When I googled I saw some links from apex users who had written as how to export using ApexExport utilities, but since we are in windows environment, we are having hard time getting the class_path,java_home...etc setup properly. I guess its not just me most of them would have encountered it.
But I am looking for an official document from Oracle ? ( exporting Apex applications from command line in Windows Environment ).
Should the page load D.A. fire not until the dom is ready? Or is this not necessarily the case.I'm running a page over a slow connection, so the event (true action: execute JS) is being executed before the page is ready to handle the code. I would think this event should not run until the DOM is ready.
I have confirmed this by wrapping the code in document.ready, and it behaves as expected.
How to save and edit a Word template and excel (extension. doc and. xls), which can be opened to allow the document and record all changes made by the user of the pacification.
I need to create a forgot password page in which there will be two text box named user name and email id and user will provide his usename and email id in those text box. so apex will check that the provided name and email id are there in the data base and if email id corresponds to right user name then a mail will be send to that email Id containing auto generated password.
I have a doubt; can we format a particular word in oracle reports at runtime..?
Ex:-
A text filed contains data Quote:We request #BANK# to finance the same Bill as per agreed interest rate and other terms and conditions agreed on the above addendum and immediately remit the proceeds to our account A/c no. #ACCOUNTNO#, held with your Bank.
We need to make #BANK#, #ACCOUNTNO# are bold at runtime, Is there any method to format characters at runtime..?
I used Region, Process by to search the report which appears as shown above. Then I use Choose Auditors column to select my Auditor and copy paste it into the report under To be Audited By col. Is there a way to automate the process. I am here using a tabular form in APEX. My main aim is to assign auditors based on Region, not equal to Processed by.
how to use checkbox item, and trying to get checked options values via application global arrays. So, this may be quite simple question, but I'm completely stuck here...
When I was looking through various threads and guides, I've encountered checkbox corresponding array names like "g_f01" - "g_f50". And so far i saw that these names are derived from item name in generated HTML code, for example:
<input type="checkbox" name="*f10*" value="3" />
And this one stands for array name "g_*f10*".However, when I tried to do the same thing - i receive item name which looks like "*p_v04*", and therefore, I can't figure out, which array name should I choose to adress it properly.
i'm generating some document to pdf and sending them to a company. When they print them out the images in the pdf aren't very good, although they look ok in the pdf. i think it's a gif format at the minute.
what is the best image format for the best quality?
I just want to know whether we can mask salary column of number datatype into text ,like we used to_char(to_date(<column_name>,'j'),'jsp') in sql? for example
I want to use superscript / subscript just like in word in rdf (oracle 8i / reports 6) for creating a footnote. for e.g. reserch1 . 1 should appear on top . is it possible to in reports to do that.
I want to hide the URL or Username and password in web.show_document. While accessing report through form any end user can see the url. I need to hide the credentials.
I have had a request to add the word "continued" if a field has to print on more than one page. For example, if there are values associated with a city, and these values and city must print on another page, the user would like the word "continued" on the second, third, etc iteration of the city.
example:
page 1 Fort Worth value value value
THEN next page, continuing the rest of Fort Worth's values:
page 2 Fort Worth continued <--the word "continued" added for next pg value value value
When I give the report Full path like 'C:FolderNameCurrency2.rdf. Successfully report run.
after changing the registry path like Reports_Path='C:FolderName'
When I click a button to run the report,I received the following errors.
declare v_report_nameVARCHAR2(100) := 'Currency2.rdf'; begin Web.Show_Document('http://hoitvoltes5:9002/reports/rwservlet?usr'||'&report='||v_report_name,'_blank'); end ; " REP-110: File Currency2.rdf cannot be opened. REP-1070: An error occurred while opening or saving a document. REP-0110: File Currency2.rdf cannot be opened."
