Can u have more than one layout in report

1 Answer

Answer :

It is possible to have more than one layout in a report by using the
additional layout option in the layout editor.

Related questions

Description : How can a square be drawn in the layout editor of the Report writer?

Last Answer : By using the rectangle tool while pressing the (Constraint) key.

Description : Can u have more than one layout in report

Last Answer : It is possible to have more than one layout in a report by using the additional layout option in the layout editor. Answer: Yes it is possible to run the report without parameter form by setting the PARAM value to Null

Description : Can u run the report with out a parameter form

Last Answer : Yes it is possible to run the report without parameter form by setting the PARAM value to Null

Description : What is the lock option in reports layout

Last Answer : By using the lock option we cannot move the fields in the layout editor outside the frame. This is useful for maintaining the fields .

Description : What is a Layout Editor?

Last Answer : The Layout Editor is a graphical design facility for creating and arranging items and boilerplate text and graphics objects in your application's interface.

Description : Does a grouping done for objects in the layout editor affect the grouping done in the data model editor?

Last Answer : No.

Description : How many minimum groups are required for a matrix report

Last Answer : The minimum number of groups in matrix report are 4

Description : s it possible to disable the parameter from while running the report?

Last Answer : Yes

Description : Can a field be used in a report without it appearing in any data group?

Last Answer : Yes

Description : What are the minimum number of groups required for a matrix report

Last Answer : The minimum of groups required for a matrix report are 4 e

Description : To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Last Answer : & physical page no.

Description : What are the various methods of performing a calculation in a report ?

Last Answer : 1. Perform the calculation in the SQL statements itself. 2. Use a calculated / summary column in the data model.

Description : At what point of report execution is the before Report trigger fired?

Last Answer : After the query is executed but before the report is executed and the records are displayed.

Description : Give the sequence of execution of the various report triggers?

Last Answer : Before form , After form , Before report, Between page, After report.

Description : How can a button be used in a report to give a drill down facility?

Last Answer : By setting the action associated with button to Execute pl/sql option and using the SRW.Run_report function.

Description : How can a text file be attached to a report while creating in the report writer?

Last Answer : By using the link file property in the layout boiler plate property sheet.

Description : Is it possible to modify an external query in a report which contains it?

Last Answer : No.

Description : What are the ways to monitor the performance of the report?

Last Answer : Use reports profile executable statement. Use SQL trace facility.

Description : What are the two types of views available in the object navigator(specific to report 2.5)?

Last Answer : View by structure and view by type .

Description : If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Last Answer : While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.

Description : Is the After report trigger fired if the report execution fails?

Last Answer : Yes.

Description : What in a pivot table dialog box can change Excel report to layout mode?

Last Answer : What is the answer ?

Description : How do u implement the If statement in the Select Statement

Last Answer : We can implement the if statement in the select statement by using the Decode statement. e.g select DECODE (EMP_CAT,'1','First','2','Second'Null); Here the Null is the else statement where null is done .

Description : Can u change the mouse pointer ? How?

Last Answer : Yes. Specifies the mouse cursor style. Use this property to dynamically change the shape of the cursor.

Description : Can u have VBX and OCX controls in forms ?

Last Answer : Yes.

Description : Can u have OLE objects in forms?

Last Answer : Yes.

Description : Can u set default font in forms?

Last Answer : Yes. Change windows registry(regedit). Set form45_font to the desired font.

Description : Can u change VAT at run time?

Last Answer : Yes. You can programmatically change an object's named visual attribute setting to change the font, color, and pattern of the object at runtime.

Description : Can u port applictions across the platforms? how?

Last Answer : Yes we can port applications across platforms.Consider the form developed in a windows system.The form would be generated in unix system by using f45gen my_form.fmb scott/tiger

Description : Can U disable database trigger? How?

Last Answer : Yes. With respect to table ALTER TABLE TABLE [[ DISABLE all_trigger ]]

Description : Is it possible to split the print reviewer into more than one region?

Last Answer : Yes

Description : Can a primary key contain more than one columns?

Last Answer : Yes

Description : Is it possible to attach same library to more than one form?

Last Answer : Yes

Description : Can you have more than one content canvas view attached with a window?

Last Answer : Yes. Each window you create must have atleast one content canvas view assigned to it. You can also create a window that has manipulated content canvas view. At run time only one of the content canvas views assign to a window is displayed at a time.

Description : Why is it that Trump has declared that he will close the Mexico – U.S. Border at the same time that the full Mueller report becomes public ?

Last Answer : The announcements were independent, not connected, and neither has a definite date set, just general time frames. There is no rational to closing the border other than it redirects attention to the GOP’s inability to have a coherent immigration policy that makes sense.

Description : U.S. News And World Report Ranks Hybrid SUVs ?

Last Answer : U.S. News and World Report ranked the Lexus RX 450h as the best hybrid SUV in the U.S. The RX 450h has the same luxury and reliability as its gasoline powered sister with much ... of hybrid vehicles. A higher purchase price in exchange for lower fuel consumption and a smaller carbon footprint.

Description : Where can one get more information about TCL? (for DBA

Last Answer : One can write custom event checking routines for OEM using the TCL (Tool Command Language) language. Check the following sites for more information about TCL: . The Tcl Developer Xchange - ... the OraTCL package . Tom Poindexter's Tcl Page - Oratcl was originally written by Tom Poindexter

Description : Which is more faster - IN or EXISTS?

Last Answer : EXISTS is more faster than IN because EXISTS returns a Boolean value whereas IN returns a value.

Description : What is Functional Setup Manager or FSM as it is more commonly known as?

Last Answer : Oracle Fusion Functional Setup Manager (FSM) is an application that provides an end to-end guided process for managing your functional implementation projects throughout the entire implementation life cycle.

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

Description : How does one use the import/export utilities? (for DBA

Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).

Description : what is a display item?

Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

Description : What is import/export and why does one need it? (for DBA

Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.

Description : Are there any troubleshooting tips for OEM? (for DBA

Last Answer : . Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create ... successfully. Check the log to see the results of the execution rather than relying on this status.