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

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

1 Answer

Answer :

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

Related questions

What is mouse navigate property of button?

Description : What is mouse navigate property of button?

Last Answer : When Mouse Navigate is True (the default), Oracle Forms performs standard navigation to move the focus to the item when the operator activates the item with the mouse. When Mouse Navigate is set ... the resulting validation) to move to the item when an operator activates the item with the mouse.

Can a button have icon and lable at the same time ?

Description : Can a button have icon and lable at the same time ?

Last Answer : NO

Give the sequence of execution of the various report triggers?

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

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

How many minimum groups are required for a matrix report

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

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

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

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

Last Answer : Yes

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

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

Last Answer : Yes

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

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

Can u run the report with out a parameter form

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

Can u have more than one layout in report

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.

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

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.

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

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.

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

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.

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

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.

How can a square be drawn in the layout editor of the report writer?

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.

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

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

Last Answer : No.

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

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

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

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

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 .

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?

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.

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

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

Last Answer : Yes.

Are drill sergeants trying to get one to stand up for yourselves or trying to break one down and submit?

Description : Are drill sergeants trying to get one to stand up for yourselves or trying to break one down and submit?

Last Answer : Pretty much they want everyone to do exactly as they’re told, and also to work closely as a team. Lots of times that will require some breaking down because most people show up in the military pretty stuck on themselves.

How to create Drill-Down reports?

Description : How to create Drill-Down reports?

Last Answer : To cut the story short: - By grouping data on required fields -Then toggle visibility based on the grouped filed

My database is down and I cannot restore. What now? (for DBA

Description : My database is down and I cannot restore. What now? (forDBA

Last Answer : Recovery without any backup is normally not supported, however, Oracle Consulting can sometimes extract data from an offline database using a utility called DUL (Disk UnLoad). This utility reads data in the ... as an absolute last resort and will most likely cost your company a lot of money!!!

Could you please list down some of common task used during implementation

Description : Could you please list down some of common task used during implementation

Last Answer : Here are few basic and frequently used task 1. Manage Enterprise HCM Information 2. Manage Legal Entity HCM Information 3. Manage Legal Addresses 4. Manage Legal Entity 5. Manage Location ... Lookups 20. Manage Goal Management Notification Settings P.S. Task names are not case-sensitive

How does one give developers access to trace files (required as input to tkprof)? (for DBA)

Description : How does one give developers access to trace files (required as input to tkprof)? (for DBA)

Last Answer : The "alter session set sql_trace=true" command generates trace files in USER_DUMP_DEST that can be used by developers as input to tkprof. On Unix the default file mask for these files are "rwx r-- -- ... = true Include this in your INIT.ORA file and bounce your database for it to take effect.

Give two methods you could use to determine what DDL changes have been made.

Description : Give two methods you could use to determine what DDL changes have been made.

Last Answer : You could use Logminer or Streams

Give the stages of instance startup to a usable state where normal users may access it.

Description : Give the stages of instance startup to a usable state where normal users may access it.

Last Answer : STARTUP NOMOUNT - Instance startup STARTUP MOUNT - The database is mounted STARTUP OPEN - The database is opened

Give two examples of referential integrity constraints.

Description : Give two examples of referential integrity constraints.

Last Answer : rential integrity constraints.

Give the two types of tables involved in producing a star schema and the type of data they hold.

Description : Give the two types of tables involved in producing a star schema and the type of data they hold.

Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

Give the reasoning behind using an index.

Description : Give the reasoning behind using an index.

Last Answer : Faster access to data blocks in a table.

Give two examples of how you might determine the structure of the table DEPT.

Description : Give two examples of how you might determine the structure of the table DEPT.

Last Answer : Use the describe command or use the dbms_metadata.get_ddl package.

Give the structure of the function ?

Description : Give the structure of the function ?

Last Answer : FUNCTION name (argument list .....) Return datatype is local variable declarations Begin executable statements Exception execution handlers End;

Give the structure of the procedure ?

Description : Give the structure of the procedure ?

Last Answer : PROCEDURE name (parameter list.....) is local variable declarations BEGIN Executable statements. Exception. exception handlers end;

Give built-in routine related to a record groups?

Description : Give built-in routine related to a record groups?

Last Answer : Create_group (Function) Create_group_from_query(Function) Delete_group(Procedure) Add_group_column(Function) Add_group_row(Procedure) Delete_group_row(Procedure) Populate_group(Function) Populate_group_with_query(Function) Set_group_Char_cell(procedure)

Give the Types of modules in a form?

Description : Give the Types of modules in a form?

Last Answer : Form Menu Library

Give the equivalent term in forms 4.0 for the following. Page, Page 0?

Description : Give the equivalent term in forms 4.0 for the following. Page, Page 0?

Last Answer : Page - Canvas-View Page 0 - Canvas-view null.

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

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

Name the two files that are created when you generate the form give the filex extension ?

Description : Name the two files that are created when you generate the form give the filex extension ?

Last Answer : INP (Source File) FRM (Executable File)

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Description : Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Last Answer : a. ON-INSERT b. POST-INSERT c. PRE-INSERT

Why it is need to give public facility provided by government to public. How it is connected to development of country? -SST 10th

Description : Why it is need to give public facility provided by government to public. How it is connected to development of country? -SST 10th

Last Answer : This answer was deleted by our moderators...

What colour button down shirt should I wear under a black sweater vest?

Description : What colour button down shirt should I wear under a black sweater vest?

Last Answer : Black goes with anything, remember?

Corporate boardroom styles which is better casual or button down suit and ties?

Description : Corporate boardroom styles which is better casual or button down suit and ties?

Last Answer : I believe there is dress code , whatever the boss wears.. Hooters people are more relaxed. Trump people want to look professional they can make money. If I was a man I would do the suit not casual.

Why are there options to go up or down on an elevator and not just.. one button?

Description : Why are there options to go up or down on an elevator and not just.. one button?

Last Answer : They’re built that way to optimize the speed of the elevator. It groups together travelers moving in the same direction.

How does one properly tuck in a dress shirt (button down)?

Description : How does one properly tuck in a dress shirt (button down)?

Last Answer : answer:Just tuck it in, nothing too special here. Make sure the bunchy parts are evenly distributed, and it’s a little less bunchy in the front that anywhere else. You also want it tucked it tight – don’t pull it up at all to make it looser – you want to avoid looking ‘poofy’. good luck :)

What to do To delete a tab from the horizontal ruler point to the desired tab symbol hold down the left mouse button and then?

Description : What to do To delete a tab from the horizontal ruler point to the desired tab symbol hold down the left mouse button and then?

Last Answer : What is the answer ?

You can shut down the computer by pressing: a) Window Button + ZZ b) Ctrl + UU c) Window Button + UU (windows+UU is only for windows XP) d) None of These

Description : You can shut down the computer by pressing: a) Window Button + ZZ b) Ctrl + UU c) Window Button + UU (windows+UU is only for windows XP) d) None of These

Last Answer : c) Window Button + UU (windows+UU is only for windows XP)

Do you have a checklist or drill for getting on board with a new computer?

Description : Do you have a checklist or drill for getting on board with a new computer?

Last Answer : No need to follow routine or anything. Laptops generally comes with OS and all the necessary programs pre installed. So you just need to backup/transfer your personal/work files into the new system. That ... where you left off. You can also remove the hard drive of the old laptop for save keeping.

Without a drill press, what is a trick for drilling a truly vertical hole in board?

Description : Without a drill press, what is a trick for drilling a truly vertical hole in board?

Last Answer : Stand a bubble level near the place-of-drillage, and rest the dorsal edge of the drill against the long edge of the level. Ask a friend to hold the level, if necessary.

How can I avoid taking a drill to three oil pans?

Description : How can I avoid taking a drill to three oil pans?

Last Answer : Buy some big oil drip pans, fill with cat litter and place under the leaking engines. Gaskets are a thing but the leaks might be (probably are) valve covers. Put a friendly note on the windshields informing owners that ... for him to just dump 2 to 3 quarts of oil into it each day. (WHAT a mess!!)

Are there any drill team parents on Fluther, and do you have any tips for me?

Description : Are there any drill team parents on Fluther, and do you have any tips for me?

Last Answer : Don’t let her use live ammo.

I am wanting to buy a cordless drill. Can you explain the differences to me?

Description : I am wanting to buy a cordless drill. Can you explain the differences to me?

Last Answer : Battery life and power will be greater the higher the voltage. Personally I would recommend a corded drill. Cordless drills always seem to run out of power just when you need it most and or are never charged.