Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\TDPAX\td_blddptrprt.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Modifying the Departments Report</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:17:39Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Modifying the Departments Report" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11946-01" /> <link rel="copyright" href="../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="../dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface.htm" title="Home" type="text/html" /> <link rel="up" href="build_app.htm" title="Building Your Application" type="text/html" /> <link rel="up" href="td_blddptrprt.htm" title="Modifying the Departments R..." type="text/html" /> <link rel="prev" href="td_bldinitapp.htm" title="Previous" type="text/html" /> <link rel="next" href="td_bldaddrf.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="build_app.htm" title="Building Your Application">Building Your Application</a> > Modifying the Departments R...</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="td_bldinitapp.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="td_bldaddrf.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BCEBJJGB" name="BCEBJJGB"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1><a name="TDPAX04004|how to modify the Departments report"></a>Modifying the <a id="sthref166" name="sthref166"></a>Departments Report</h1> <p>When you run the Create Application Wizard, the wizard creates forms and reports based on the selections you make. Behind the scenes, Application Express writes a query for you to extract the appropriate data from the database.</p> <p>In this exercise, you modify the query for the <a id="sthref167" name="sthref167"></a><a id="sthref168" name="sthref168"></a>Departments report to include information from the <code>OEHR_EMPLOYEES</code> table.</p> <p>To modify the Departments report:</p> <ol> <li> <p>Click the <span class="bold">Edit Page 2</span> link on the Developer toolbar (at the bottom of the page).</p> <p>The Page Definition for Page 2 appears. A <span class="bold">page</span> is the basic building block of an application. Pages contain user interface elements such as tabs, lists, buttons, items, and regions. To see the definition of each page belonging to your application, you use the Page Definition page. For more information, see <a href="td_gsappbld.htm#BEHJCDAD">"What Is Application Builder?"</a>.</p> </li> <li> <p>Under Page Rendering, locate the Regions section.</p> <img src="img/reg_sect.gif" alt="Description of reg_sect.gif follows" title="Description of reg_sect.gif follows" longdesc="img_text/reg_sect.htm" /><br /> <a id="sthref169" name="sthref169" href="img_text/reg_sect.htm">Description of the illustration reg_sect.gif</a><br /> <br /></li> <li> <p>Click <span class="bold">Departments</span>.</p> </li> <li> <p>Scroll down to Source, and replace the default Region Source script with the following:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT d.department_id "Department ID", d.department_name "Department Name", count(e2.employee_id) "Number of Employees", substr(e.first_name,1,1)||'. '|| e.last_name "Manager Name", c.country_name "Location" FROM oehr_departments d, oehr_employees e, oehr_locations l, oehr_countries c, oehr_employees e2 WHERE d.manager_id = e.employee_id AND d.location_id = l.location_id AND d.department_id = e2.department_id AND l.country_id = c.country_id AND instr(upper(d.department_name),upper(nvl(:P2_REPORT_SEARCH,d.department_name))) > 0 GROUP BY d.department_id, d.department_name, substr(e.first_name,1,1)||'. '||e.last_name, c.country_name </pre></li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> <div class="sect2"><!-- infolevel="all" infotype="General" --><a id="sthref170" name="sthref170"></a> <h2>Running the <a id="sthref171" name="sthref171"></a><a id="sthref172" name="sthref172"></a><a id="sthref173" name="sthref173"></a><a id="sthref174" name="sthref174"></a>Page</h2> <p>To see how the page looks to end users, run the page. When you run a page, the Application Express engine dynamically renders and processes the page to display viewable HTML.</p> <p>To run the page:</p> <ul> <li> <p>Click the <a id="sthref175" name="sthref175"></a>Run Page icon in the upper right corner.</p> <img src="img/runpg_iconrow.gif" alt="Description of runpg_iconrow.gif follows" title="Description of runpg_iconrow.gif follows" longdesc="img_text/runpg_iconrow.htm" /><br /> <a id="sthref176" name="sthref176" href="img_text/runpg_iconrow.htm">Description of the illustration runpg_iconrow.gif</a><br /> <br /></li> </ul> <p>The revised Departments report appears.</p> <img src="img/bldap_deptexp.gif" alt="Description of bldap_deptexp.gif follows" title="Description of bldap_deptexp.gif follows" longdesc="img_text/bldap_deptexp.htm" /><br /> <a id="sthref177" name="sthref177" href="img_text/bldap_deptexp.htm">Description of the illustration bldap_deptexp.gif</a><br /> <br /> <p>Note that the revised report has three additional columns: Number of Employees, Manager Name, and Location. Also note that your data might appear in a different order. You can ignore this difference and continue with the steps.</p> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="../dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="td_bldinitapp.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="td_bldaddrf.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de