In Oracle 10g, How to call a report since an option of a menu (*.mmb)
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?
I understand that you had sent me everything,
October 11, 2015
View Thread Other 12 Replies on community.oracle.com
I sent for example to you that, no to insert it in your item's menu code,
then,You have to modify it.
a menu (mmb) doesn't have to define him reports
objects... then, what parameter I send to the
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:
repid := find_report_object('report2');
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_EXECUTION_MODE, RUNTIME);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_COMM_MODE, SYNCHRONOUS);
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.
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
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.
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
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
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
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
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
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
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
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
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
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
Hi, Hi, Env: 18.104.22.168.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
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
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
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
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
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,
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