Topics: Hands-On 10: Drill Down or Push Button
report
You have done so
good and your client asks you to create a drill down report on the company’s
stock information so they get more detailed information about that company’s
shares holders. Your report should have push button to call company’s shares
holder from the previous Hands-On 09. The report should show for the security
shown on the screen all customers of that security, the amount of their
position, and the total number of shares held.
You will learn
how to: use push button to execute another report, use or pass parameter, use
the “select parent frame” icon, use or open objects property, compile report,
use the boilerplate, write and compile PL/SQL trigger, use “runtime
pre-viewer.”
|
More Resources by
Google: |
|
|
|
|
Open report
number 2 (stock history).
Save it as report
number 8.
Run the report.
Navigate through
the report.
Here, add a push
button to list the company's shares holders.
Click on the
"layout model" icon.
Click on the
company item, and click on the "Parent Frame" icon until the handlers do not
change.
Drag the handler
to make more space.
Click again on
the company item, and click once on the "Parent Frame" icon.
Then drag the
handler.
Click on the push
button icon and move the cross cursor to the “layout editor” and click and
drag to make a push button.
Right click on it
and open its property.
Type “Customer's
list” on the text box.
Change the “type”
property to "pl/sql” and then double click on the “pl/sql” trigger.
Write a code to
call report number 8 (customers list).
The binding
variable is used to pass the company symbol as a parameter.
Write all the
exception.
Compile the
trigger.
Successfully
compiled.
Close the window.
Close the
property palette.
Close the “Layout
Model” window.
Remove report 7,
since we don’t need it.
Open report 8 --
customers list.
Compile the
report just to make sure the executable code is created.
Then remove the
report.
Run the new
report.
To test the push
button, you should use the "runtime pre-viewer” option.
Click on
"customer's list" to run the report.
Navigate through
the report pages and then click on the customer's list to see the company's
shares holders.
After the testing
was done, close the windows and save the changes.
Now, you should
practice this over and over, until you become a master at it.
Good Luck!
|