Oracle Reports How to use Formula column

Показать описание

.

Today we will learn about Oracle reports formula. I mean How to use formula in a column in Oracle reports.
For this just try to follow the steps which are given below----

Step 1: create a simple Group Above report to use formula in oracle report.
Step 2: Go to the Paper Layout option to use formula in oracle report
Step 3: Copy a number data type field from the paper layout to use formula in oracle report
Step 4: and place your copied field in the right area as I have shown in the videos to use formula in oracle report
Step 5: After this go to the Data Model option to use formula in oracle report
Step 6: and click to the formula tool and sketch the right group area to use formula in oracle report.
Step 7: after this it will create a formula column and will take a default unique name to use formula in oracle report.
Step 8: double click on the name an it will transfer you to its property inspector to use formula in oracle report.
Step 9: Just change the data type and write down the Function in the PL/SQL area to use formula in oracle report.
Step 10: then close it to to use formula in oracle report.
Step 11: go to the design option and select the field what you have copied and go to its property inspector.
Step 12: Just replace the data source option to the formula name to use formula in oracle report.
Step 13: then close it and compile it and then click to the Run report option.
Step 14: Your desired value will return in that field by using formula.

..................................................Finish..................................................

To get my others videos just go to the link which is given below..

Stay connected with information...
Stay Connected with my tutorial..
Stay connected with updated reports tutorial...
Keep learning about Oracle Databese .......

Thanks for watching...

Subscribe my Channel : Mahfujur Rahman

Subscribe my channel : Mahfujur Rahman

Thanks For Watching
MdMahfujur Rahman
Database Design and Development
IDB-BISEW IT Scholarship Project.
01673472384