p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Beginning Oracle Application Express ISBN: 9780470388372 (http://p2p.wrox.com/book-beginning-oracle-application-express-isbn-9780470388372-474/)
-   -   Pg.84 Last Paragraph - master detail report/product name (http://p2p.wrox.com/book-beginning-oracle-application-express-isbn-9780470388372/77044-pg-84-last-paragraph-master-detail-report-product-name.html)

waylock November 15th, 2009 04:27 PM

Pg.84 Last Paragraph - master detail report/product name
In the last paragraph of this chapter on Pg. 84, the author challenges the reader to attempt to change the PRODUCT_ID column for the PRODUCT_NAME column in the master detail report in Order Items Detail.

I've had a problem doing this successfully. I was able to get it to work but it showed all orders instead of the specific order. To no avail, I was unable to get it to work.

A couple issues which seemed to be different than the previous exercise spanning pages 81-84.

1. The report doesn't show up as an "Interactive Report". I got around this by creating a new Region which was an Interactive Report. I then copied the following SQL into that report:


2. I also have some confusion around the difference between the Report on Products Page and the Order Items Page since the later seems to be a "Form" and how that relates back to the task at hand.

3. A non-related question, somehow along the way my pages have different numbers than the examples in the book which adds confusion while trying to follow along. Can I easily change the page name/number to reflect the same number scheme used in the book?

Thank you!

waylock November 15th, 2009 06:07 PM

Revised - Pg.84 Question
I read on into Chapter 4 and my first question was answered. I'm still processing it all thought.


peace95 November 20th, 2009 02:45 PM


Athough I have been through the entire book, I had to go back and review what is actually happening.
2. In pages 81-84, one of the main points to capture is creating or using a table as your LOV (List of Values) in the Master-Detail when ordering items. When order items, the customer is not concern about the product.id per se just the product name. However the product.id is past to the detail portion of the report, in this case the product form.

3. I would not suggest to change the page numbers, because if you notice in the process page some pages are automatically set for example in a redirect, etc. However, I strongly suggest when you finish an exercise to pencil in your book the page or pages apex created. The pages I really remembered by heart is the Master-Detail page number, it is used throught out the book and I started over 3 times.

Have fun!! You will learn much.

All times are GMT -4. The time now is 07:14 PM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.