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

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

1 Answer

Answer :

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

Related questions

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.

List out the various methods available for performing for analog multiplier.

Description : List out the various methods available for performing for analog multiplier.

Last Answer : • Logarithmic summing technique • Pulse height /width modulation technique • Variable transconductance technique • Multiplication using gilbert cell • Multiplication technique using transconductance technique

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.

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 button be used in a report to give a drill down facility?

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.

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.

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

What are the different methods of backing up oracle database ?

Description : What are the different methods of backing up oracle database ?

Last Answer : Logical Backups - Cold Backups - Hot Backups (Archive log)

Which of the above methods is the faster method?

Description : Which of the above methods is the faster method?

Last Answer : performing the calculation in the query is faster.

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

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.

What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Description : What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Last Answer : Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.

What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?

Description : What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?

Last Answer : An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.

What are the Various Block Coordination Properties

Description : What are the Various Block Coordination Properties

Last Answer : The various Block Coordination Properties are a) Immediate Default Setting. The Detail records are shown when the Master Record are shown. b) Deffered with Auto Query Oracle Forms defer fetching the ... No Auto Query The operator must navigate to the detail block and explicitly execute a query

What are the Various Master and Detail Relation ships.

Description : What are the Various Master and Detail Relation ships.

Last Answer : The various Master and Detail Relationship are a) NonIsolated :: The Master cannot be deleted when a child is exisiting b) Isolated :: The Master can be deleted when the child is exisiting c) Cascading :: The child gets deleted when the Master is deleted.

What are various constraints used in SQL?

Description : What are various constraints used in SQL?

Last Answer : NULL -NOT NULL -CHECK -DEFAULT

What are various privileges that a user can grant to another user?

Description : What are various privileges that a user can grant to another user?

Last Answer : SELECT -CONNECT -RESOURCES

What are various joins used while writing SUBQUERIES?

Description : What are various joins used while writing SUBQUERIES?

Last Answer : Self join-Its a join foreign key of a table references the same table. Outer Join--Its a join condition used where One can query all the rows of one of the tables in the join condition even though ... in which one or more columns in one table are equal to one or more columns in the second table.

What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Description : What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Last Answer : Destype and Desname.

What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Description : What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Last Answer : Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.

What is the use of hidden column? What are the various sub events a mouse double click event involves?

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

Last Answer : A hidden column is used to when a column has to embed into boilerplate text.

What is the use of place holder column? What are the various sub events a mouse double click event involves?

Description : What is the use of place holder column? What are the various sub events a mouse double click event involves?

Last Answer : A placeholder column is used to hold calculated values at a specified place rather than allowing is to appear in the actual row where it has to appear.

How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Description : How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Last Answer : By dragging the column outside the group.

What are the various type of snapshots?

Description : What are the various type of snapshots?

Last Answer : Simple and Complex.

A report on factual findings is the end product of the auditor when performing: a. Audit. b. Review. c. Agreed-upon procedures. d. Compilation

Description : A report on factual findings is the end product of the auditor when performing: a. Audit. b. Review. c. Agreed-upon procedures. d. Compilation

Last Answer : Agreed-upon procedures

A report on factual findings is the end product of the auditor when performing: a. Audit. b. Review. c. Agreed-upon procedures. d. Compilation.

Description : A report on factual findings is the end product of the auditor when performing: a. Audit. b. Review. c. Agreed-upon procedures. d. Compilation.

Last Answer : Agreed-upon procedures

Conflict between financial statement users and auditors often arises because of the a. High cost of performing an audit. b. Expectation gapc. Technical vocabulary which the auditoruses in the report.d. Placement of the auditor's report in theback of the client's annual report where itis hard to locate

Description : Conflict between financial statement users and auditors often arises because of the a. High cost of performing an audit. b. Expectation gap c. Technical vocabulary which the auditor uses in the report. d. ... auditor's report in the back of the client's annual report where it is hard to locate

Last Answer : Expectation gap

The methods or algorithms which are used to increase the performance of disk storage sub-system is called ............. A) Disk performing B) Disk scheduling C) Disk storing D) Disk extending

Description : The methods or algorithms which are used to increase the performance of disk storage sub-system is called ............. A) Disk performing B) Disk scheduling C) Disk storing D) Disk extending

Last Answer : B) Disk scheduling

Oxygen is utilised by the organism to (a)_____ breakdown nutrietns molecules the (b)_____ and to derive (c)______ for performing various activities

Description : Oxygen is utilised by the organism to (a)_____ breakdown nutrietns molecules the (b)_____ and to derive (c)______ for performing various activities

Last Answer : Oxygen is utilised by the organism to (a)_____ breakdown nutrietns molecules the (b)_____ and to derive (c)______ for performing various activities

Oxygen is utilised by the organism to (a)_____ breakdown nutrietns molecules the (b)_____ and to derive (c)______ for performing various activities

Description : Oxygen is utilised by the organism to (a)_____ breakdown nutrietns molecules the (b)_____ and to derive (c)______ for performing various activities

Last Answer : Oxygen is utilised by the organism to (a)_____ breakdown nutrietns molecules the (b)_____ and to derive (c)______ for performing various activities

Modulation is theprocessof A. converting analogsignals todigital signals B. converting digital signals toanalog signals C. Multiplexing various signals intohigh speed line signals D. performing data encryption

Description : Modulation is theprocessof A. converting analogsignals todigital signals B. converting digital signals toanalog signals C. Multiplexing various signals intohigh speed line signals D. performing data encryption

Last Answer : converting digital signals toanalog signals

Demodulation is aprocessof A. converting analog to digital signals B. converting digital to analogsignals C. multiplexing various signals intoone high speed line signals D. performing data description

Description : Demodulation is aprocessof A. converting analog to digital signals B. converting digital to analogsignals C. multiplexing various signals intoone high speed line signals D. performing data description

Last Answer : converting analog to digital signals

There are four conditions that give rise to the need for independent audits of financial statements. One of these conditions is consequence. In this context, consequence means that the: a. Users of the statements may not fully understand the consequences of their actions. b. Auditor must anticipate all possible consequences of the report issued. c. Impact of using different accounting methods may not be fully understood by the users of the statements. d. Financial statements are used for important decisions

Description : There are four conditions that give rise to the need for independent audits of financial statements. One of these conditions is consequence. In this context, consequence means that the: a. ... fully understood by the users of the statements. d. Financial statements are used for important decisions

Last Answer : Financial statements are used for important decisions

What are the various methods of soil conservation? -Geography

Description : What are the various methods of soil conservation? -Geography

Last Answer : Many different Methods of soil conservation: 1. Contour Plowing - Originating in ancient Phoenicia, Contour Plowing involves plowing grooves into the desired farmland, then planting the crop ... of nitrogen fertilizer and fungicides can increase yields and protect crops from drought and flooding.

What are the various methods of soil conservation? -SST 10th

Description : What are the various methods of soil conservation? -SST 10th

Last Answer : Methods of soil conservation: 1. Contour ploughing: Ploughing along the contour lines can check the flow of water down the slopes. It is called contour ploughing. It can be practised on ... contributed significantly to the stabilisation of sand dunes and in stabilising the desert in western India.

Give various methods of rainwater harvesting since ancient times. -SST 10th

Description : Give various methods of rainwater harvesting since ancient times. -SST 10th

Last Answer : . Guls or Kuls: In hilly and mountainous regions, people built diversion channels called Kuls or Guls in the Western Himalayas. A Kul or Gul leads to a circular village tank, from ... of Rajasthan, almost all the houses traditionally had underground tanks or tankas for storing drinking water.

Boron can be obtained by various methods but not by :

Description : Boron can be obtained by various methods but not by :

Last Answer : Boron can be obtained by various methods but not by : A. Reduction of `B_(2)O_(3)` with Mg B. ... with `H_(2)` D. electrolysis of fused `BCl_(3)`

What were the various methods Travis used in his attempts to keep old yeller from wandering off during at night?

Description : What were the various methods Travis used in his attempts to keep old yeller from wandering off during at night?

Last Answer : Feel Free to Answer

The purity of an isolated protein can be tested by employing various methods. (A) Solubility curve (B) Molecular weight (C) Ultra Centrifugation (D) Immuno Ractivity (E) All of these

Description : The purity of an isolated protein can be tested by employing various methods. (A) Solubility curve (B) Molecular weight (C) Ultra Centrifugation (D) Immuno Ractivity (E) All of these

Last Answer : Answer : C