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

1 Answer

Answer :

Yes

Related questions

Description : For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Last Answer : Yes

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 : Can a repeating frame be created without a data group as a base?

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

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 : 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 : 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 : Is the After report trigger fired if the report execution fails?

Last Answer : Yes.

Description : What is Legislative Data Group in Fusion HCM?

Last Answer : Legislative data groups are a means of partitioning payroll and related data. At least one legislative data group is required for each country where the enterprise operates. Each legislative data group ... and is associated with a legislative code, currency and its own cost key flexfield structure.

Description : How do I stop the ratings field from constantly appearing in iTunes?

Last Answer : answer:View -> View Options, uncheck it. Make sure you are on the library when you do so. I think that different playlists can have their own display options.

Description : Can strangers make sure drunk girls get home safely without appearing to have sexual intentions?

Last Answer : answer:I don't think you need to worry about it. You did a nice thing, just to be happy about that and to Hell with anyone who has a problem with it. On the other hand, I drove a drunk woman ... about not seeing her again. If she gets that drunk then she would probably lead you to a world of hurt.

Description : There is a % sign in one field of a column. What will be the query to find it?

Last Answer : '' Should be used before '%'.

Description : How image_items can be populate to field in forms 4.0?

Last Answer : A fetch from a long raw database column PL/Sql assignment to executing the read_image_file built_in procedure to get an image from the file system.

Description : .Can you attach an alert to a field?

Last Answer : No

Description : Can you attach an lov to a field at design time?

Last Answer : Yes

Description : Can you attach an lov to a field at run-time? if yes, give the build-in name.?

Last Answer : Yes. Set_item_proprety

Description : List the system variables related in Block and Field?

Last Answer : 1. System.block_status 2. System.current_block 3. System.current_field 4. System.current_value 5. System.cursor_block 6. System.cursor_field 7. System.field_status.

Description : Can we use GO-BLOCK package in a pre-field trigger ?

Last Answer : No

Description : Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?

Last Answer : No

Description : What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?

Last Answer : On-validate-field trigger fires, when the field Validation status New or changed. Post-field-trigger whenever the control leaving form the field, it will fire.

Description : What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

Last Answer : When you changes the Existing value to null, the On-validate field trigger will fire post change trigger will not fire. At the time of execute- query post-change trigger will fire, on-validate field trigger will not fire.

Description : s it possible to set a filter condition in a cross product group in matrix reports?

Last Answer : No

Description : What is the use of break group? What are the various sub events a mouse double click event involves?

Last Answer : A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.

Description : Use the add_group_column function to add a column to record group that was created at a design time?

Last Answer : False

Description : What is a Query Record Group?

Last Answer : A query record group is a record group that has an associated SELECT statement. The columns in a query record group derive their default names, data types, had lengths from the database columns ... rows retrieved by the query associated with that record group. What is a Non Query Record Group?

Description : How many number of columns a record group can have?

Last Answer : A record group can have an unlimited number of columns of type CHAR, LONG, NUMBER, or DATE provided that the total number of column does not exceed 64K.

Description : Can a formula column referred to columns in higher group?

Last Answer : Yes

Description : Can object group have a block?

Last Answer : Yes , object group can have block as well as program units.

Description : What are object group?

Last Answer : An object group is a container for a group of objects. You define an object group when you want to package related objects so you can copy or reference them in another module.

Description : Use the ADD_GROUP_ROW procedure to add a row to a static record group? I) TRUE II)FALSE

Last Answer : I) FALSE

Description : Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE

Last Answer : II) FALSE

Description : What is a record Group?

Last Answer : A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table

Description : What is a record Group?

Last Answer : A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table

Description : What is the built-in routine used to count the no of rows in a group?

Last Answer : Get_group _row_count System Variables

Description : What triggers are associated with the radio group?

Last Answer : Only when-radio-changed trigger associated with radio group Visual Attributes.

Description : What are the different type of a record group?

Last Answer : Query record group Static record group Non query record group

Description : What is a radio Group?

Last Answer : Radio groups display a fixed no of options that are mutually Exclusive. User can select one out of n number of options.

Description : How many maximum number of radio buttons can you assign to a radio group?

Last Answer : Unlimited no of radio buttons can be assigned to a radio group

Description : How can a group in a cross products be visually distinguished from a group that does not form a cross product?

Last Answer : A group that forms part of a cross product will have a thicker border.