Forms :: Create Main Menu For Calling Reports
Dec 3, 2010Application developed in form builder 6i.Now I want to create main menu for calling forms and reports.
Should I use buttons or drop down menu?
ADVERTISEMENT
Forms :: How To Design Hierarchical Tree Menu For Calling Reports
Mar 17, 2013How to design Hierarchical Tree Menu for calling forms & Reports.
View 2 Replies View RelatedForms :: Getting Error Frm 21011 While Calling From Menu
Jun 5, 2012getting error frm 21011 , ora -65020 , while calling forms from menu , the forms are also passing parameters between forms 1 and forms 2 .
The following code is in menu item .
declare
uname varchar2(30);
cname varchar2(40);
[code]....
Forms :: Run Reports From Menu?
Feb 14, 2010Recently i migrated all my forms and reports from 6i to 10.I am able to run the reports in the web.But when I am trying to run thru menu it give me error
Invalid report id -frm 41219
(I had already searched the forum for the same but i didnt get any valid answer. )
In the forum some says to add the report in the object navigator The reports node is available for the forms only but not for the menus then how can i add the report? Below is the code i am using in the menu
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
plid ParamList;
[code]...
Forms :: How To Create Icon Menu
May 29, 2010I want to create icon menu.
It fails to upload the images (newrec, saverec, delrec, etc) even the path is given in ICON_FILE_NAME.
Forms :: Create Menu Role With User
Jul 19, 2010how to create menu with submenu according to user,
For Example :
Menu1 have got 02 SubMenu :
SubMenu1 just user1 see.
SubMenu2 just for user2.
And user3 could access SubMenu1 and SubMenu2.
Forms :: Create Menu Item In Run Time
Apr 22, 2010can i create menu item in the run time ?
View 3 Replies View RelatedCreate Context Sensitive Menu In Oracle Forms 10g
Jan 18, 2010I'm trying to find out if I can create a context sensitive menu in Oracle Forms 10g. So far I haven't found much in the way of info. where I can find some sample code or a demo I can learn from?
The idea being that when a user right clicks an item they are then presented with relevent options for that item.
Forms :: Hierarchy Tree Menu - Call Reports Through Node
Jun 12, 2012I have a hierarchy tree menu look like this
+GL
Accounts
Inform
+Export
Export Entry Form
+Security
New User Entry
when i click Gl==>Accounts, accounts form opens and i want call my forms and reports through nodes.
Forms :: Calling Reports From Oracle 10g
Mar 18, 2012We are facing a problem when calling the reports from oracle forms 10g. following error message appears during report generation
Rep-52266: The In-Process reports server IT_BHARAT failed to start.oracle.reports.RWException:IDL:Oracle/reports/RWException:1.0
Why this error message is appearing and how to solve. Please find attached the image file showing the problem details.
Forms :: Calling Reports 9i - Argument Can't Be Null
Oct 3, 2005I am calling report9i from forms9i. i am getting following error
invalid report id
when i call a report from form in when button pressed trigger. And also giving the following error
argument(1) can't be null.
v_rep varchar2(100);
v_rep := run_report_object('report5',pl_id);
or
rep_object report_object;
v_rep varchar2(100);
rep_object := find_report('report5');
v_rep := run_report_object(rep_object,pl_id);
where pl_id is the parameter list.
Forms :: Calling Multiple Reports Through Alert
Feb 15, 2011I need code for calling two reports using alerts.
View 4 Replies View RelatedReports & Discoverer :: Footer Layout In Main Section?
Oct 8, 2010I have test in the main section of the layout in forms. I want to print the footer on the first page only. If I go to properties and select print object on first page, it still prints the footer in all pages. How can I force the footer on the first page only.
View 1 Replies View RelatedReports & Discoverer :: How To Run Discoverer Reports In A Forms Menu
Jul 5, 2010how to Run a Discoverer Reports in a Forms Menu.
View 2 Replies View RelatedForms :: How To Display Menu Instead Of Default Menu
Apr 19, 2013i have one form name is LOV.fmb and i have one menu name is summit_menu.mmb how to display menu instead of default menu.
View 2 Replies View RelatedReports & Discoverer :: How To Join Head / Main And Trailer Section
Feb 10, 2012i have generate a report using report wizard but i want to know how join main section and head section , what ever you do in report wizard impact in main section ,i have done some head section ,when i run report, head section run first and main section in next page .. how to join both sections in single page output..
View 2 Replies View RelatedReports & Discoverer :: Launching Discoverer Viewer From Forms Menu
Dec 6, 2011Is it possible to link to Discoverer Viewer from Forms without requiring the user to log in again. If so, can I then link to a specific Workbook within Discoverer?
View 2 Replies View RelatedReports & Discoverer :: REP-0801 When Increasing Height / Width Of Paper Layout Header / Main Or Trailer
Apr 14, 2013I understand when I decrease the width or height of the paper layout, it may cause this error if any of the objects in my report may not fit in the new layout.
But for me this error occurs even when I increase the size of my report paper layout!
Reports & Discoverer :: Calling Reports From Stored Procedures?
Feb 23, 2011Is there a way to call an oracle report (version 9i) from a stored procedure?
View 2 Replies View RelatedReports & Discoverer :: How To Run Report In Menu
Oct 19, 2011How can I run my report in my main menu or fort page for example I want to run my report when user click a button. What will process?
View 5 Replies View RelatedApplication Express :: Create Tab Menu Like In Sumneva Site
Aug 28, 2012i want to create tab menu like in sumneva site URL.....
View 13 Replies View RelatedForms :: Data Not Displaying From Main Database?
Jul 25, 2012on clicking select.show,while running the form data(DATE and APPLICANT_NO) is being accesed from local database but after uploading the form the data is not coming from main database,even if the data is present in the main database.
View 1 Replies View RelatedCreate A Table Which Contain History Of Main Table
Sep 8, 2008I have to create a table which contain history of a main table. like this:
if the main table is
========================
nametypelengthnot null
Avarchar5Y
Bvarchar5N
Cvarchar5N
Dvarchar5N
========================
[code]....
I've plan to so this by create a trigger in main_table. my problem is my main table have a lot of fields and I can't write a code to control it 1 by 1 like :
if old.A <> new.a
insert into history("A",old.A,new.a)
if old.B <> new.B
insert into history("B",old.b,new.b)
......
I decided to select column name from the data dictonary using this SQL:
SELECT column_name FROM user_tab_columns WHERE table_name = '<<Table Name>>';
and then do a loop over the resultset and use the column name I've got , like this (its just an idea, may be not a write syntax):
BEGIN
.....
FOR i IN 1..:result.COUNT LOOP
if ld.colname[i] <> :new.colname[i]
INSERT INTO history
VALUES ( colname[i], ld.colname[i], :new.colname[i]);
END LOOP;
END;
but I can't write a "old.colname". I try with " old.'colname' ", " ld.'colname' " but it won't work.how to create a history file like I've describe.
Reports & Discoverer :: Calling Program Units?
May 8, 2013How to call program unit(procedure/function/package) in to report is it like formula column & placeholder?if not, how to call external (procedure/function/package) in to report
View 1 Replies View RelatedReports & Discoverer :: Calling Report From A Form (both 6i) On 11g Database
May 28, 2011i am facing another problem with 11g database. i am using 6i forms and reports and recently shifted database to 11g 64 bit version. as its 6i forms so i use run_product to call reports. suppose my code for runproduct is in a button, once i press the button to get the print i am getting the logon_screen. if i enter login data again its giving the report.
View 1 Replies View RelatedReports & Discoverer :: Calling Report From Form Asking Enter Password
Nov 28, 2010I am calling a report from Form 6i by using RUN_PRODUCT.After pressing the call button from Form 6i, report is showing box for enterning user id and password.
View 5 Replies View RelatedReports & Discoverer :: Hiding Username / Password When Calling From Hyperlink HTML?
Jun 30, 2010Can we hide the username/password@dbname from hyperlink html, so that when ever we change our user password we should not change in each report calling from another report
View 1 Replies View RelatedReports & Discoverer :: How To Create Oracle Reports With Java Barcodes
May 24, 2010how to create Oracle Reports with Java Barcodes.
View 8 Replies View RelatedForms :: Add Scroll Bar On Menu?
Jul 26, 2013I am working on oracle 10g forms.my menu is so long and I want to add a vertical scroll bar to my menu .
View 6 Replies View RelatedForms :: How To Get Menu Item Name
May 5, 2009I have created a Menu in forms 6i,
I want to get Menu Item Name When i pressed any menu item in runtime..
e.g, i have a menu items like,
MENU1
ITEM1
ITEM2
ITEM3
when i pressed ITEM1 then it should display ' MENU1.ITEM1 ',
how can i get this..?
REMEMBER !! I WANT TO GET MENU ITEM NAME IN RUNTIME , WHICH IS CREATED IN DESIGN TIME.