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..
• Oracle Reports How to use Formula column
• How to use parameter as well as Param...
• Oracle Reports How to create a Simple...
• Oracle Reports: Introduction to Oracl...
• How to create menu smart bar in oracl...
• Oracel forms tutorial in bengali How ...
• Oracle forms 10g How to create list item
• How to create calender in oracle form...
• Oracle Forms Tutorial in Bangla How t...
• Oracle Forms Tutorial in bangla Creat...
• Oracle Forms Tutorial How to convert ...
• PLSQL tutorial in Bangla calculation ...
• Oracle Forms tutorial in bangla How t...
• Oracle Forms tutorial in bangla How t...
• Oracle forms tutorial in bangla Datab...
• Oracle forms tutorial in begali How t...
• Oracle Forms Tutorial How to clearify...
• Oracle forms Tutorial Part 2 How to u...
• Oracle Forms Tutorial How to make a s...
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
