Oracle Reports Formula

.

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

https://youtu.be/rWU2DBCaTf8
https://youtu.be/OL6Stb9II30
https://youtu.be/_dr-KZIs_fQ
https://youtu.be/BTYDJR0zIiQ
https://youtu.be/1n1Wej_uWsA
https://youtu.be/ynLFjILA0wY
https://youtu.be/GeSic9Dwt5A
https://youtu.be/z31hMeb5H5w
https://youtu.be/4qHR96zOTCM
https://youtu.be/LhPN_bTWAj8
https://youtu.be/KHqtbplh7c0
https://youtu.be/UbcHcggmZAc
https://youtu.be/99Gfy2eVaWU
https://youtu.be/xLCQ7FVKlbA
https://youtu.be/ncFD3vDMt-M
https://youtu.be/LrQ_9-jlEko
https://youtu.be/aHKfJa-qmks
https://youtu.be/Egm-92rvoaM
https://youtu.be/YUja468gbWA


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