Invalid ID calling report from oracle forms 10 G

Advertisement

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(100);
     Rep_status VARCHAR2(20);
BEGIN
     repid := FIND_REPORT_OBJECT('PLAN_FUZZY');
     V_rep := RUN_REPORT_OBJECT(repid);
END;

Advertisement

hey,
May i know have u attached the report to your form???
i think the best way is using RUN_OBJECT method
Run_Product(REPORTS, 'report_path', SYNCHRONOUS, RUNTIME,
FILESYSTEM, NULL, NULL);
if your report is at reportxx folder then you can just write report file name.
Hope it will help you.

November 30, -0001

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

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

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

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

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

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

Issue calling report from a Form(11.1.2).

Hi, I have an existing code in the form to call a report and it seems to be working in the current 10g version of production server and I am migrating forms 10g to 11gR2. My issue here is when, I want to call the report from Forms 11g ( i.e. in devel

Generating a Report from Oracle Forms

If a want to generate a report in Oracle Reports by pressing a Button on my Oracle Forms for example for 5 text items on that form ...then how do i do it ??? plz helpwell when i create a report module in the object navigator of oracle forms its opens

How to avoid IE pop-ups when running BIP reports(w/ SSO) from Oracle Forms?

Hi all, We have an OID/SSO integrated Oracle Forms and BI Publisher environment in place. We/users expect the same behavior when running Oracle Reports or BIP reports from Oracle Forms... which means receiving no intermediate pop-ups and simply getti

Passing a value for date parameter from Oracle Forms to BIP

Hi I have created a report with the following SQL query: select d_tables.d_seq, to_date(d_tables.d_created) creation_date, d_tables.d_created_by created_by, d_tables.d_pk, d_tables.table_name, d_tables.comments from d_tables, d_applications where d_t

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

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

REP 110 & REP 0110 .calling reports from Form 10g(10.1.2.0.2)

Hi All, We are migrating form from Oracle form 6i to Oracle 10g(10.1.2.0.2). I am calling reports from forms using Web.Show_Docment(). When we run reports in report builder 10g it works fine. But when we try to run reports from Forms 10g it throws er

Calling web service from oracle forms fails with ORA_JAVA.JAVA_ERROR

Problem Description: I'm following the steps as per the doc: http://www.oracle.com/technology/products/forms/htdocs/10gr2/howto/webservicefromforms/ws_10_1_3_from_forms.html to create a java stub to call external web service and then use java importe

HOW TO Call REPORT from FORM usning a Button ?

Hi All, Please Help me and Help other Beginers in this : Hot to call a report from a form using WHEN_BUTTON_PRESSED trigger (using Oracle 10g R1) Should i save the report as .rdf or .jsp ? Should i save the report in a specific path ? Should i add th

Calling Report from Form Error ORA-06508

Dear all, I want migrate from Fom6i to Oracle Developer Suite 10g (10.1). Folder Form = C:\APLIORA\IRS\FORM Folder Report = C:\APLIORA\IRS\REPORT I have modified file DEFAULT.ENV FORMS_PATH=C:\APLIORA\IRS\FORM;C:\APLIORA\IRS\REPORT i do not have prob

How to call OA Framework Page from Oracle Forms?

Hi, I have read the OA Guide on "Forms / OA Framework Page Integration" which guide on how to launch OA framework pages from Oracel Applications Forms. I would like to perform the same whereby to call the OAF page from Oracle Form itself. Howeve

Calling a Report from a Form

I have uploaded my form to the app server and compiled to Linux. I have copied my RDF file to the reports_path/demo directory. I can run the report via a link from our portal using the URL as follows: /reports/rwservlet?report=IndRpt.rdf&desformat=pd

Supressing the parameter form when calling report from form...

Hi everybody I call a report from a form passing a parameter. After pressing the button, the runtime parameter from appears. How do I suppress it so that the report appears right after pressing the button??? Thanks SergueiHi Serguei , You have to add