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

https://youtu.be/OL6Stb9II30

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

https://www.youtube.com/channel/UCFcO...
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