In Oracle 10g, How to call a report since an option of a menu (*.mmb)

Advertisement

Hello
In Oracle 10g, working since the browser, how to call a report since an option of a menu (*.mmb)? I know to call it in a form (*.fmb), therefore uses the fields bean area and the objects reports, but in a menu there is not neither canvas, neither fields, neither reports. Someone would be able to help me with that?
Kisses. Thanks.
Annie

Advertisement

I understand that you had sent me everything,
I sent for example to you that, no to insert it in your item's menu code,
then,You have to modify it.
... but
a menu (mmb) doesn't have to define him reports
objects... then, what parameter I send to the
function FIND_REPORT_OBJECT:
This is not true
Try out this, and then let me know
You do not need to have a report object defined in the menu. It is enough to have it in forms.
I tried to call a report from the menu in the folowing way:
I created a menu and wrote the following code in one item:
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
BEGIN
repid := find_report_object('report2');
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_EXECUTION_MODE, RUNTIME);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_COMM_MODE, SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'pdf');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'reportserver1');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESNAME,'C:\p.pdf');
v_rep := RUN_REPORT_OBJECT(repid);
END;Then I created a form with a report object called report2.
I attached the menu to this form and while running this form, I was able to successfully run the report.
In your case, you have to make sure that you have the dummy report object in each form that will have this attached menu.
You can replace by the actual report name as you have written in the code.
Regards

October 11, 2015

In Oracle 10g, How to call a report since an option of a menu (*.mmb)

Hello In Oracle 10g, working since the browser, how to call a report since an option of a menu (*.mmb)? I know to call it in a form (*.fmb), therefore uses the fields bean area and the objects reports, but in a menu there is not neither canvas, neith

How to call a report without BI Publisher-authentication

Could we call a report without BI Publisher-authentication ? Our infrastructure needs some reports that can be call with no authentication. Is there a configuration to do this? Any help will be really appreciated. ThanksYes, Enable the guest account.

How to call a report in forms 10

Dear all, i want to call a report in forms 10g and i do not know which function to use. best regards, ShoOoShrun_report_objects - form help : DECLARE repid REPORT_OBJECT; v_rep VARCHAR2(100); rep_status VARCHAR2(20); BEGIN repid := FIND_REPORT_OBJECT

How to call a report via a URL, showing a parameter prompt, but no controls

Hi, I want to be able to call a report online by passing in the URL to Portal. Want to show a prompt for a parameter value and nothing else, until the parameter is entered. I can get the report to display the parameter and the controls, and I can get

How to call a report in a form

dear sir I am new to form and report 9i I am calling a report from a form by using run_report_object I am not geting properly please help meRespected Sir, I just write the message i am geting FRM - 41219 : cannot find report : invalid id I am having

How to run BW reports since BI JAVA is not available in 7.4.

We have Upgrade our BW 7.0 to BW 7.4 on HANA, How to run our BW reports since BI JAVA is not available in 7.4. My scenario: Producer Portal (BW portal ) we are creating/marinating Portal objects ( Folders, roles, work sets --etc.), which replicate in

How to call oracel report through ADF

I need to call execute oracle report through. ADF any one have idea?Check this out. http://andrejusb.blogspot.com/2007/07/opening-report-window-in-adf-faces.html -ArunRead other 2 answers

Oracle 10g, how to determine allocated memory is healthy or sufficient.

Hi Guys, I have a 10.2.0.5 production database. Currently my server has 8GB physical RAM. 3GB is allocated to the SGA and 1GB to the PGA. Let's say one day there is a requirement from application (eg, weblogic) to increase connection pool from 20 to

How to call standard report in web dynpro abap.

Hi All,    I need the output of one standard report e.g RHXSTR00 on web dynpro abap.    How can I achieve this?    Please help!!! Points will be rewarded.    Thanks in advance! Cheers, Darshna.Hi Darshna, The report result is ALV and in most of the c

How to call ABAP report in portal

Hi, I have a ABAP report which is created and i want to display this in Portal . Any idea how i can do the same. Please, give me all the details in step-by-step. Thanks & Regards, Ashish MehtaHi,    Try this: 1. Create a transaction iView in the port

How to call a javascript function from oracle apex 3.2.1 (oracle 11g)

Hello , I want to use javascript for client side validations in oracle apex 3.2.1 and i am using oracle 11g. how to call a function for a submit button where i will validate the existance of data for a control and submit the page once validated. wher

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

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 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

How to run a report from oracle 10g form in .csv format

dear all, how to run a report from oracle 10g form in .csv format? i've already run in pdf & excel format. i'm using SET_REPORT_OBJECT_PROPERTY (ro_report_id, report_desformat, 'PDF'); --for pdf SET_REPORT_OBJECT_PROPERTY (ro_report_id, report_desfor

How to call Oracle Report 6i from a java swing/ejb codes (client server)

Hi to all. We now have to do reports using Oracle Reports that have to call from Java Swing (interface) / EJB (Backend). How can we call the Oracle Reports 6i from Java Swing? Do anybody done that?...Any ideas? Where should we find the resourse, if a

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

Samples template for oracle 10g reports

Hi, I need a oracle 10g reports sample templates were we need to make modifications and use it. if any body has the sample templates can share with me or where can i get the sample templates. Please advice.In your $ORACLE_DEV_HOME/reports/templates,

User reports in Oracle 10g

How difficult is it for non-technical users to generate their own ad hoc reports in Oracle 10g?If they are non-technical , then, somebody technical have to generate adhoc reports for them.Read other 2 answers