Previous  Next          Contents  Index  Navigation  Glossary  Library

Using Oracle FastFormula to Define QuickPaint Reports

In the Define QuickPaint Report window, you can paste database items from a list into the Report Definition area and enter free text to label the data. When you save your QuickPaint Report definition, a formula is generated automatically.

Formulas generated from QuickPaint do not include conditional logic or calculations. You may want to add these features, for example to sum up compensation elements or to report different data for different assignments.

Attention: If you want to add features to a generated QuickPaint formula, you must copy the formula and edit the copy. If you edit the original, your edits will be overwritten if the formula is regenerated from the QuickPaint definition.

Example

In this example, the generated QuickPaint formula has been edited to add Line 09, which totals the input values used in the report.

LINE01=''
LINE02=' Pay Items      Value this Period
LINE03=''
LINE04=' Salary Value : ' + TO_TEXT(trunc((SALARY_ANNUAL/12),2))
LINE05=' Item 1 Value : ' + TO_TEXT(ITEM_1_PAY_VALUE)
LINE06=' Item 2 Value : ' + TO_TEXT(ITEM_2_PAY_VALUE)
LINE07=' Bonus Value  : ' + TO_TEXT(BONUS_AMOUNT)
LINE08='                __________________'
LINE09='        Total : '+ TO_TEXT(trunc((
(SALARY_ANNUAL/12)+ITEM_1_PAY_VALUE+ITEM_2_PAY_VALUE+BONUS_AMOUNT),2))
LINE10=''
LINE11=''
LINE12=''
RETURN LINE01, LINE02, LINE03, LINE04, LINE05, LINE06, LINE07, 
       LINE08, LINE09, LINE10, LINE11, LINE12, 

To make a copy of a QuickPaint formula:

See Also

Defining QuickPaint Reports


         Previous  Next          Contents  Index  Navigation  Glossary  Library