How to call Reports in oracle forms 10g

Advertisement

Dear All,
How to call Reports in oracle forms 10g.
I am using Oracle Forms 10g Reports 10g and Database 10 and and Operating system Windows XP.
Please give me the Solution.
Thanks and Regards,
Faziludeen

Advertisement

Hi Omkar,
Please check the following code.
DECLARE
  repid REPORT_OBJECT;
  v_rep VARCHAR2(100);
  rep_status VARCHAR2(20);
  plid ParamList;
BEGIN
  plid := Get_parameter_List('tmp');
  IF NOT Id_Null(plid) THEN
  Destroy_parameter_List( plid );
  END IF;
  plid := Create_parameter_List('tmp');
  add_parameter(plid,'p_parameter',text_parameter,to_char(:POLICY.POLICY_NO));
  Add_parameter(plid, 'PARAMFORM', TEXT_parameter, 'NO');
  repid := FIND_REPORT_OBJECT('POL_REP');
  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,cache);
  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
  SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER, 'paramform=no');
  v_rep := RUN_REPORT_OBJECT(repid,plid);
  rep_status := REPORT_OBJECT_STATUS(v_rep);
  WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
  LOOP
  rep_status := report_object_status(v_rep);
  END LOOP;
  WEB.SHOW_DOCUMENT('http://'||'LENOVO-428E9E41'||'8889'||'/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?
  '||'server=prod_report_server&P_parameter='||:POLICY.POLICY_NO||
  '&paramform=no');
END;
I am used to Start the Report sever   'Rwserver Server=prod_Report_Server Start'
OracleAS Report Services
Version :-   10.1.2.0.2
Name    :-   prod_report_server
Status  :-   Server is Shutting down
Jobs in Queue  0
Active Engines  0
I got the Following Error when I trying to run the Report
FRM-41211: Integration error:SSL failure running another product
Thanks and Regards,
Faziludeen

October 11, 2015

How to call Reports in oracle forms 10g

Dear All, How to call Reports in oracle forms 10g. I am using Oracle Forms 10g Reports 10g and Database 10 and and Operating system Windows XP. Please give me the Solution. Thanks and Regards, FaziludeenHi Omkar, Please check the following code. DECL

Urgent: Calling Reports from Oracle Forms 10g (10.1.2.0.2) fails

Problem displaying a report from within Oracle 10g forms. After a lot of work, we are able to access and actually display a report directly from Internet explorer and view the report from the report server as well. The successful url was: http://york

Calling Crystal Reports from Oracle Forms 10G

Hi everyone, I am trying to call a crystal report from Oracle Forms 10G. I have a button on my Form which when clicked calls a Crystal Report which the uaser then wants to save as a PDf file. Can someone please send me the code to do this and also th

Calling Report From Oracle Forms

Hi I am calling this one report from oracle forms, I am using global temporary table to run that report. I am first inserting data into the temporary table through oracle form and then i am calling report in that form to view the data in that tempora

How to call reports 6i or forms 6i directly from oracle procedure

Hi, Hi, Env: 6.0.8.25.2 (forms 6i/reports 6i) Database: Oracle 10g r2 We are running a client server environment and not web based. I want to run the forms 6i or reports 6i directly from a database procedure/function and not by creating a procedure i

How to send a character mode report from Oracle Form 10g to a printer.

how sending a character mode report from Oracle 10g report to a printer. I'm sending to a printer located in the network i have theses parameter report desformat = prtname desname=?????? destype= ????? mode=character i would like to preview the repor

How to call refcursor in oracle forms

How to fetch a column in oracle form by using DB prcedure's refcursor. There was not isseu to create and call the procedure in oracle forms but when I was trying to fetch a particular column and assing the value to text box, I got an error invalid re

Invalid ID calling report from oracle forms 10 G

Hi, I have a problem during calling a report object 10g from a FORM, the source code is below the message, an the error message is can't not find PLAN_FUZZY (my report module name)...... WHY ??? DECLARE      repid REPORT_OBJECT;      v_rep VARCHAR2(1

How to call java classed in forms 10g

Hi I am using forms 10g There is a java class email_class (to send emails and attachments). this java class (email_class) has further used two moere .jar files (activation.jar & mail.jar). Now I want to use this java class (email_class) in my form to

Oracle reports 6i to Oracle forms 10g migration

Hi, I have .rdf files which were created on Oracle Reports 6i. I would like to migrate the .rdf files into Oracle Reports module which is present as a part of Oracle Forms 10g to generate PDF output. Please let me know the detailed steps to be follow

Calling crystal reports 11 from oracle forms 10g

Could you provide me step by step a solution on how I can call crystal reports 11 from oracle forms 10g application.Hi, Use web.show_document for calling the reports. Check out forms online help for syntax and example of web.show_document. -ArunRead

How to invoke crystal reports from Oracle forms 11g R2 along with passing p

How to invoke crystal reports from Oracle forms 11g R2 along with passing parameter to it. how to pass parameters to crystal report, please help.how to pass parameters to crystal report, please help.This would entirely depend on crystal reports and y

Calling Java Script to open a Map (Like Google Map) from Oracle Forms 10g

Hello, We are on Oracle EBS rel 12, Forms 10g. We have a requirement of calling a Custom Map application (Like Google Maps) from Oracle Forms 10g. When the user enters the address like town, city, country etc and clicks on a button there should be a

Calling Word document from Oracle Forms 10g

Hi all, I would like to call a Microsoft Word document from my Oracle Forms 10g. What would be the best way to do this? Thank you in advance.Have you tried something like WEB.SHOW_DOCUMENT('file:///<documentpath>','_blank');Read other 2 answers

Re: Configuring Jinitiator for Oracle Forms 10g Using IE 8.0

Hi team, iam facing difficulty in running the Oracle Forms 10g , using IE 8.0. What are the settings i need to perform while running the forms, please help me. While Running : http://localhost:8889/forms/frmservlet the tab is not getting crashed and

Error while importing java class into oracle forms 10g

Hi I have generated a web service client using jdeveloper 10g. It consists of complex type methods. I am trying to import the class files using java importer in oracle form 10g. I am able import all of them successfully except one. That one is the ma

Controlling scanner thru Oracle forms 10g

Please if anybody can provide me with how to control the scanner thru forms 10g thru PL/SQL , Java or any other means,,, Please its urgentWell it depends - what interface does the scanner support when it connects to the machine? Is it a scanner (as i

Oracle form 10g  java error

I am going to create the graph in oracle form 10g ...i replace the java folder on the already created java folder. when i run the form i have this error. error...java.lang.unsupportedclassversion /oracle/form/fd/laf_xp_button(unsupported.major.minor.

DDE.initiate is not working in oracle forms 10g

Previously i have used DDE for uploading the data from excel to DB in oracle forms 10g.now it is throwing non-oracle exception at DDE.intiate. could you please help me to solve this issue. i use the below code APPLICATION := OLE2.CREATE_OBJ('EXCEL.AP

How to genetare reports(ssrs) with form library's data in sharepoint 2010

Hi, How to genetare reports (ssrs) with form library's data in sharepoint 2010.I am saving infopath(2010) xml form data in form library.I have 500 and more forms in the form library( more forms can come in future).How to generate reports from this xm