How to use parameter as well as Parameter list in oracle reports
After watching this tutorial you will able to learn About
How to user Parameter as well as Parameter List at run time in Oracle Reports Builder....
• How to use parameter as well as Param...
Step 1: Create a simple report by using Oracle reports Wizard.
Step 2: After creating the report go to its data model source
Step 3: Click to the data source from where the group information started.
Step 4: After double clicking there you will see the sql query
Step 5: write the WHERE condition and name the prameter name with colon
Step 6: Click to the OK button
Step 7: Then Run your report
Step 8: After running there will show a parameter form builder
Step 9: write down your desired info into the box then press ENTER.
Step 10: You will See the changes and will find only your desired information.
Step 11: After this now we will create a parameter list.
Step 12: Just go to the Parameter Layout from TOOL. Menu
Step 13: Select the parameter name and the go to its property inspector.
Step 14: Change the data type as your data source
Step 15: Write down the initial value.
Step 16: After that click to the parameter list.
Step 17: It will show you a window where you have to write in the select command
Step 18: Write down the sql command from which you data will be retrieved.
Step 19: Then click OK. and Run your report.
Step 20: Your parameter layout will generate a parameter list in its layout editor.
Step 21: Select your desired id or no. and then press ENTER.
Step 22: Your report will run as your estimated wish.
...................................................Finish..................................................
To get my others videos just go to the link which is given below..
/ @websyntax
• 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
