Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\bldapp_rpt_att.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>Editing SQL and Wizard Reports</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:28Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Editing SQL and Wizard Reports" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11947-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="app_comp.htm" title="Adding Application Components" type="text/html" /> <link rel="up" href="bldapp_rpt.htm" title="Creating Reports" type="text/html" /> <link rel="up" href="bldapp_rpt_att.htm" title="Editing SQL and Wizard Reports" type="text/html" /> <link rel="prev" href="bldapp_rpt_create.htm" title="Previous" type="text/html" /> <link rel="next" href="bldapp_rpt_int.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="app_comp.htm" title="Adding Application Components">Adding Application Components</a> > <a href="bldapp_rpt.htm" title="Creating Reports">Creating Reports</a> > Editing SQL and Wizard Reports</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="bldapp_rpt_create.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_rpt_int.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BCEIEEDJ" name="BCEIEEDJ"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB05018|report, editing attributes"></a>Editing SQL and Wizard <a id="sthref980" name="sthref980"></a><a id="sthref981" name="sthref981"></a><a id="sthref982" name="sthref982"></a><a id="sthref983" name="sthref983"></a><a id="sthref984" name="sthref984"></a><a id="sthref985" name="sthref985"></a><a id="sthref986" name="sthref986"></a>Reports</h1> <p>You can control report layout, pagination, column sorting, error messages, export links, and column break of SQL and Wizard reports (or classic reports) using the Report Attributes page.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">Tip:</p> With the addition of interactive reports in Oracle Application Express release 3.1, all previous report types are referred to as classic reports. See <a href="bldapp_rpt_int.htm#CHDEFABF">"Editing Interactive Reports"</a>.</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="sthref987" name="sthref987"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="#CHDGABID">Accessing Classic Report Attributes</a></p> </li> <li> <p><a href="#CHDDCJEE">Altering Classic Report Layout Using Column Attributes</a></p> </li> <li> <p><a href="#BCEDFBGH">Controlling Classic Report Pagination</a></p> </li> <li> <p><a href="#BCECBEGF">Enabling Column Sorting in a Classic Report</a></p> </li> <li> <p><a href="#BCEGJBFD">Adding a Download Link to a Classic Report</a></p> </li> <li> <p><a href="#CHDCEGJJ">Enabling the CSV Output Option in a Classic Report</a></p> </li> <li> <p><a href="#CEGFEEEJ">Exporting a Classic Report as an XML File or a CSV File</a></p> </li> <li> <p><a href="#BCECBBGH">Creating a Column Link in a Classic Report</a></p> </li> <li> <p><a href="#BCEDBJFH">Defining an Updatable Column in a Classic Report</a></p> </li> <li> <p><a href="#BCECDBCB">Defining a Column as a List of Values in a Classic Report</a></p> </li> <li> <p><a href="#BCEBDIFA">Controlling When Columns Display in a Classic Report</a></p> </li> <li> <p><a href="#BCEDBBBJ">Controlling Column Breaks in a Classic Report</a></p> </li> </ul> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Tutorials:</p> <span class="italic"><a href="http://www.oracle.com/pls/db112/lookup?id=HTMAD">Oracle Application Express Advanced Tutorials</a></span></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="CHDGABID" name="CHDGABID"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25346" id="HTMDB25346"></a>Accessing Classic Report Attributes</h2> <p>You can access the classic Report Attributes page by clicking the <span class="bold">Report</span> link next to the report region you want to edit on the Page Definition. You can also navigate to the Report Attributes page by clicking the region name and then selecting the Report Attributes tab.</p> <img src="img/rprt_edit.gif" alt="Description of rprt_edit.gif follows" title="Description of rprt_edit.gif follows" longdesc="img_text/rprt_edit.htm" /><br /> <a id="sthref988" name="sthref988" href="img_text/rprt_edit.htm">Description of the illustration rprt_edit.gif</a><br /> <br /> <p>To access the Report Attributes page:</p> <ol> <li> <p>On the Workspace home page, click the <span class="bold">Application Builder</span> icon.</p> </li> <li> <p>Select the application.</p> </li> <li> <p>Select a page.</p> <p>The Page Definition appears.</p> </li> <li> <p>Under Regions, click <span class="bold">Report</span> next to the name of the report region you want to edit.</p> <p>The Report Attributes page appears and is divided into the following sections:</p> <ul> <li> <p><span class="bold">Column Attributes</span> control the report layout. See <a href="#CHDDCJEE">"Altering Classic Report Layout Using Column Attributes"</a>.</p> </li> <li> <p><span class="bold">Layout and Pagination</span> attributes control report pagination. See <a href="#BCEDFBGH">"Controlling Classic Report Pagination"</a>.</p> </li> <li> <p><span class="bold">Sorting</span> attributes enable you to define images and image attributes for images that display in report headings to sort values. See <a href="#BCECBEGF">"Enabling Column Sorting in a Classic Report"</a>.</p> </li> <li> <p><span class="bold">Messages</span> contain attributes that enable you to define messages that display if no data is found or more data is found than can be displayed.</p> </li> <li> <p><span class="bold">Report Export</span> attributes enable you to add download link to a report or export a report as either an XML file or CSV file. See <a href="#BCEGJBFD">"Adding a Download Link to a Classic Report"</a> and <a href="#CEGFEEEJ">"Exporting a Classic Report as an XML File or a CSV File"</a>.</p> </li> <li> <p><span class="bold">Break Formatting</span> attributes enable you to control if a specific column repeats and how column breaks appear when printed. See <a href="#BCEDBBBJ">"Controlling Column Breaks in a Classic Report"</a>.</p> </li> </ul> </li> <li> <p>To learn more about a specific attribute, click the item label.</p> <p>When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See <a href="start_hlp.htm#BABDGBDB">"About Field-Level Help"</a>.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="#BCECBBGH">"Creating a Column Link in a Classic Report"</a> and <a href="#BCEDBJFH">"Defining an Updatable Column in a Classic Report"</a>, and <a href="#BCECDBCB">"Defining a Column as a List of Values in a Classic Report"</a>, and <a href="#BCEBDIFA">"Controlling When Columns Display in a Classic Report"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="CHDIIFFC" name="CHDIIFFC"></a> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h3><a name="HTMDB25347" id="HTMDB25347"></a>About Navigation Alternatives</h3> <p>The Report Attribute page is divided into these sections: Column Attributes, Layout and Pagination, Sorting, Messages, Report Export, Break Formatting, and External Processing.</p> <p>You can access these sections by scrolling down the page, or by clicking a navigation button at the top of the page.</p> <img src="img/int_rprt_nav.gif" alt="Description of int_rprt_nav.gif follows" title="Description of int_rprt_nav.gif follows" longdesc="img_text/int_rprt_nav.htm" /><br /> <a id="sthref989" name="sthref989" href="img_text/int_rprt_nav.htm">Description of the illustration int_rprt_nav.gif</a><br /> <br /> <p>When you select a button at the top of the page, the selected section appears and all other sections are temporarily hidden. To view all sections of the page, click <span class="bold">Show All</span>.</p> </div> <!-- class="sect4" --></div> <!-- class="sect3" --> <a id="CHDDCJEE" name="CHDDCJEE"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB05019|report, altering layout with Column Attributes"></a>Altering Classic Report Layout Using Column Attributes</h2> <p>You can use the Column Attributes section of the Report Attributes page to precisely control the report layout. For example, you can use these attributes to alter column heading text, change column positioning, hide a column, create a sum of a column, or select a sort sequence.</p> <p>To access the Column Attributes:</p> <ol> <li> <p>On the Workspace home page, click the <span class="bold">Application Builder</span> icon.</p> </li> <li> <p>Select the application.</p> </li> <li> <p>Select a page.</p> <p>The Page Definition appears.</p> </li> <li> <p>Under Regions, click <span class="bold">Report</span> next to the name of the report region you want to edit.</p> <p>The Report Attributes page appears with the Column Attributes section at the top of the page.</p> <img src="img/rpt_att.gif" alt="Description of rpt_att.gif follows" title="Description of rpt_att.gif follows" longdesc="img_text/rpt_att.htm" /><br /> <a id="sthref990" name="sthref990" href="img_text/rpt_att.htm">Description of the illustration rpt_att.gif</a><br /> <br /> <p>Use the Column Attributes section to control report column appearance and functionality.</p> <p><span class="bold">Heading Type</span> identifies how the heading is generated for the report. The <span class="bold">Link</span> column indicates if a column link is currently defined. The <span class="bold">Edit</span> column indicates whether a column is currently updatable.</p> <p><a href="#CHDFEFIC">Table: Common Report Column Edits for Classic Reports</a> describes common report column edits.</p> <div class="tblformal"><a id="sthref991" name="sthref991"></a><a id="CHDFEFIC" name="CHDFEFIC"></a> <p class="titleintable">Common Report Column Edits for Classic Reports</p> <table class="Formal" title="Common Report Column Edits for Classic Reports" summary="This table describes common report column edits." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="37%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t7">Description</th> <th align="left" valign="bottom" id="r1c2-t7">Developer Action</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t7" headers="r1c1-t7"> <p>Alter column display sequence.</p> </td> <td align="left" headers="r2c1-t7 r1c2-t7"> <p>Click the up and down arrows to change the column display sequence.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t7" headers="r1c1-t7"> <p>Alter heading alignment.</p> </td> <td align="left" headers="r3c1-t7 r1c2-t7"> <p>Under Column Alignment, select a column alignment.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t7" headers="r1c1-t7"> <p>Change column heading text.</p> </td> <td align="left" headers="r4c1-t7 r1c2-t7"> <p>Under Heading, enter different heading text.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t7" headers="r1c1-t7"> <p>Control which columns display.</p> </td> <td align="left" headers="r5c1-t7 r1c2-t7"> <p>Click <span class="bold">Show</span> to indicate a column should display.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t7" headers="r1c1-t7"> <p>Enable a unique sort sequence.</p> </td> <td align="left" headers="r6c1-t7 r1c2-t7"> <p>Click <span class="bold">Sort</span> and select a sequence number from <span class="bold">Sort Sequence</span>.</p> <p>Any number of columns can be sort enabled. However, at least one column must have a Sort Sequence defined.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t7" headers="r1c1-t7"> <p>Enable the sum of a column.</p> </td> <td align="left" headers="r7c1-t7 r1c2-t7"> <p>Click <span class="bold">Sum</span> to enable the sum of a column.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <p>You can further refine the attributes of a specific column on the Column Attributes page.</p> </li> <li> <p>To access the Column Attributes page, click the <span class="bold">Edit</span> icon next to the appropriate column Alias.</p> <p>To learn more about a specific attribute, click the item label.</p> <p>When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See <a href="start_hlp.htm#BABDGBDB">"About Field-Level Help"</a>.</p> </li> </ol> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="#BCECBBGH">"Creating a Column Link in a Classic Report"</a> and <a href="#BCEDBJFH">"Defining an Updatable Column in a Classic Report"</a>, and <a href="#BCECDBCB">"Defining a Column as a List of Values in a Classic Report"</a>, and <a href="#BCEBDIFA">"Controlling When Columns Display in a Classic Report"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="BCEDFBGH" name="BCEDFBGH"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB05020|report, pagination"></a>Controlling Classic Report <a id="sthref992" name="sthref992"></a><a id="sthref993" name="sthref993"></a>Pagination</h2> <p>You control report pagination by:</p> <ul> <li> <p>Including a pagination substitution string in the report template</p> </li> <li> <p>Making selections from the Layout and Pagination section on the Report Attributes page</p> </li> </ul> <p>You control how pagination displays by making selections from the Layout and Pagination attributes on the Report Attributes page.</p> <a id="sthref994" name="sthref994"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="#CHDFHBJC">Accessing and Understanding Layout and Pagination Attributes</a></p> </li> <li> <p><a href="#CHDJCGBB">Including Pagination After the Rows in a Classic Report</a></p> </li> <li> <p><a href="#CHDJBJHB">Including Pagination Before the Rows in a Classic Report</a></p> </li> </ul> <a id="CHDFHBJC" name="CHDFHBJC"></a> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h3><a name="HTMDB25348" id="HTMDB25348"></a>Accessing and Understanding Layout and Pagination Attributes</h3> <p>To access the Layout and Pagination section of the Report Attributes page:</p> <ol> <li> <p>Create a report. See <a href="bldapp_rpt_create.htm#CHDCAFBJ">"Creating a Report Using a Wizard"</a>.</p> </li> <li> <p>Navigate to the appropriate Page Definition. See <a href="bldr_goto_pgdef.htm#CJGHCACC">"Accessing a Page Definition"</a>.</p> </li> <li> <p>Under Regions, click the appropriate Report attributes link.</p> <p>The Report Attributes page appears.</p> </li> <li> <p>Scroll down to Layout and Pagination.</p> <p>You use the Layout and Pagination attributes to select a pagination style, determine where pagination occurs, and specify the number of rows that display on each page. <a href="#CEGFAICB">Table: Layout and Pagination Attributes</a> describes the most commonly used Layout and Pagination attributes.</p> <p>To learn more about a specific attribute, click the item label. When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See <a href="start_hlp.htm#BABDGBDB">"About Field-Level Help"</a>.</p> </li> </ol> <div class="tblformal"><a id="sthref995" name="sthref995"></a><a id="CEGFAICB" name="CEGFAICB"></a> <p class="titleintable">Layout and Pagination Attributes</p> <table class="Formal" title="Layout and Pagination Attributes" summary="This table describes the most commonly used Layout and Pagination attributes on the Report Attributes page." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="31%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t9">Attribute</th> <th align="left" valign="bottom" id="r1c2-t9">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t9" headers="r1c1-t9"> <p>Report Template</p> </td> <td align="left" headers="r2c1-t9 r1c2-t9"> <p>Specifies a template to be applied to this report. Report templates provide control over the results of a row from your SQL query. You can choose from a number of default templates, or pick a custom build template.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t9" headers="r1c1-t9"> <p>Report Attributes Substitution</p> </td> <td align="left" headers="r3c1-t9 r1c2-t9"> <p>Enter a value to be in place of the <code>#REPORT_ATTRIBUTES#</code> substitution string. The <code>#REPORT_ATTRIBUTES#</code> substitution string is only replaced in the before rows attribute of the report template.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t9" headers="r1c1-t9"> <p>Show Null Values as</p> </td> <td align="left" headers="r4c1-t9 r1c2-t9"> <p>Enter the text you want to display for null columns. The default value is <code>(null)</code>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t9" headers="r1c1-t9"> <p>Pagination Scheme</p> </td> <td align="left" headers="r5c1-t9 r1c2-t9"> <p>Specifies a pagination scheme for this report.</p> <p>Pagination provides the user with information about the number of rows and the current position within the result set. Pagination also defines the style of links or buttons used to navigate to the next or previous page.</p> <p>For more information, see the Help information for this attribute.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t9" headers="r1c1-t9"> <p>Enable Partial Page Refresh</p> </td> <td align="left" headers="r6c1-t9 r1c2-t9"> <p>If enabled, this attribute refreshed the report region when paginating forward and backward in your result set.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t9" headers="r1c1-t9"> <p>Display Position</p> </td> <td align="left" headers="r7c1-t9 r1c2-t9"> <p>Defines where pagination occurs.</p> <p>If you choose to display pagination above a report, the selected report template needs to support that type of display.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t9" headers="r1c1-t9"> <p>Number of Rows</p> </td> <td align="left" headers="r8c1-t9 r1c2-t9"> <p>Defines the maximum number of rows to display on each page.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t9" headers="r1c1-t9"> <p>Number of Rows (Item)</p> </td> <td align="left" headers="r9c1-t9 r1c2-t9"> <p>Defines the number of rows displayed by default per page for SQL queries (obtained dynamically from an item). Identify the item in this attribute.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t9" headers="r1c1-t9"> <p>Maximum Row Count</p> </td> <td align="left" headers="r10c1-t9 r1c2-t9"> <p>Defines the maximum number of rows to query, for example, rows 1 - 10 of 456.</p> <p>If you set this attribute to 200, the result would appear as follows:</p> <p><code>rows 1 - 10 of more than 200 rows</code></p> <p>Note that this attribute impacts performance. Counting fewer rows can improve performance and counting thousands of rows can degrade performance.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t9" headers="r1c1-t9"> <p>Strip HTML</p> </td> <td align="left" headers="r11c1-t9 r1c2-t9"> <p>Specify whether to remove HTML tags from the original column values for HTML expressions, column links and report data exported as CSV files.</p> <p>If you select values from the database that contain HTML tags, then those tags can cause conflicts with the HTML generated for your columns links or HTML expressions. When this option is enabled, only the actual data portion of your column value is used.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r12c1-t9" headers="r1c1-t9"> <p>Sort Nulls</p> </td> <td align="left" headers="r12c1-t9 r1c2-t9"> <p>For reports with column heading sorting, specify if you want null valued columns to sort first or last.</p> <p><span class="bold">See Also</span>: <a href="#BCECBEGF">"Enabling Column Sorting in a Classic Report"</a></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect4" --> <a id="CHDJCGBB" name="CHDJCGBB"></a> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h3><a name="HTMDB25349" id="HTMDB25349"></a>Including Pagination After the Rows in a Classic Report</h3> <p>To include pagination after the rows in a report:</p> <ol> <li> <p>Create a report. See <a href="bldapp_rpt_create.htm#CHDCAFBJ">"Creating a Report Using a Wizard"</a>.</p> <p>Next, select the appropriate Layout and Pagination attributes.</p> </li> <li> <p>Navigate to the Report Attributes page:</p> <ol> <li> <p>Navigate to the Page Definition. See <a href="bldr_goto_pgdef.htm#CJGHCACC">"Accessing a Page Definition"</a>.</p> </li> <li> <p>Under Regions, click the appropriate Report attributes link.</p> <p>The Report Attributes page appears.</p> </li> </ol> </li> <li> <p>Under Layout and Pagination, select the following:</p> <ol> <li> <p>Report Template - Select a report template (optional).</p> </li> <li> <p>Pagination Scheme - Select a pagination scheme.</p> </li> <li> <p>Display Position - Select a display position.</p> </li> <li> <p>Number of Rows - Specify how many rows display on each page.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </li> <li> <p>Edit the report template:</p> <ol> <li> <p>Navigate to the Page Definition. See <a href="bldr_goto_pgdef.htm#CJGHCACC">"Accessing a Page Definition"</a>.</p> </li> <li> <p>Under Templates, select the report template name.</p> </li> <li> <p>Include the <code>#PAGINATION#</code> substitution string in the After Rows attribute.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </li> <li> <p>Run the page.</p> </li> </ol> </div> <!-- class="sect4" --> <a id="CHDJBJHB" name="CHDJBJHB"></a> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h3><a name="HTMDB25350" id="HTMDB25350"></a>Including Pagination Before the Rows in a Classic Report</h3> <p>To include pagination before the rows in a report:</p> <ol> <li> <p>Create a report. See <a href="bldapp_rpt_create.htm#CHDCAFBJ">"Creating a Report Using a Wizard"</a>.</p> <p>Next, select the appropriate Layout and Pagination attributes.</p> </li> <li> <p>Navigate to the Report Attributes page:</p> <ol> <li> <p>Navigate to the Page Definition. See <a href="bldr_goto_pgdef.htm#CJGHCACC">"Accessing a Page Definition"</a>.</p> </li> <li> <p>Under Regions, click the appropriate Report attributes link.</p> <p>The Report Attributes page appears.</p> </li> </ol> </li> <li> <p>Under Layout and Pagination:</p> <ol> <li> <p>Report Template - Select a report template (optional).</p> </li> <li> <p>Pagination Scheme - Select a pagination scheme.</p> </li> <li> <p>Display Position - Select a position that contains the word top.</p> </li> <li> <p>Number of Rows - Specify how many rows display on each page.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </li> <li> <p>Edit the report template.</p> <ol> <li> <p>Navigate to the Page Definition. See <a href="bldr_goto_pgdef.htm#CJGHCACC">"Accessing a Page Definition"</a>.</p> </li> <li> <p>Under Templates, select the report template name.</p> </li> <li> <p>Include the <code>#TOP_PAGINATION#</code> substitution string in the Before Rows attribute.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </li> <li> <p>Run the page.</p> </li> </ol> </div> <!-- class="sect4" --></div> <!-- class="sect3" --> <a id="BCECBEGF" name="BCECBEGF"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB05021|report, column sorting"></a>Enabling Column <a id="sthref996" name="sthref996"></a>Sorting in a Classic Report</h2> <p>You enable column sorting on the Report Attributes page.</p> <p>To enable column sorting:</p> <ol> <li> <p>Navigate to the Report Attributes page. See <a href="#BCEIEEDJ">"Editing SQL and Wizard Reports"</a>.</p> </li> <li> <p>Under Column Attributes, select the <span class="bold">Sort</span> check box next to the columns to be sorted.</p> </li> <li> <p>From Sort Sequence, select a sequence number.</p> <p>Sort Sequence is optional. However, if there are one or more sort enabled columns, then at least one column needs a defined Sort Sequence.</p> </li> <li> <p>Scroll down to Sorting.</p> </li> <li> <p>Specify ascending and descending image attributes or click <span class="bold">set defaults</span>.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">Tip:</p> Note that column sorting must be enabled if you want columns with null values to display at the top or end of the report. To learn more about the Sort Nulls attribute, see <a href="#CHDFHBJC">"Accessing and Understanding Layout and Pagination Attributes"</a>.</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="BCEGJBFD" name="BCEGJBFD"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25351" id="HTMDB25351"></a>Adding a Download Link to a Classic <a id="sthref997" name="sthref997"></a>Report</h2> <p>You can create a link within a report that enables users to export the report as a comma-delimited file (.csv) file. To add a CSV link to a report you must enable the CSV output option. When using the CSV output option, the report template is not important. You can include a CSV link with any report template that has the CSV export substitution string defined.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="bldr_attr_global.htm#BABHABJD">"Automatic CSV Encoding"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="CHDCEGJJ" name="CHDCEGJJ"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25352" id="HTMDB25352"></a>Enabling the CSV Output Option in a Classic Report</h2> <p>To use the enable the Enable CSV output option:</p> <ol> <li> <p>Navigate to the appropriate Report Attributes page. See <a href="#BCEIEEDJ">"Editing SQL and Wizard Reports"</a>.</p> </li> <li> <p>Scroll down to Report Export.</p> </li> <li> <p>From Enable CSV output, select <span class="bold">Yes</span>.</p> </li> <li> <p>(Optional) In the Separator and Enclosed By fields, define the separator and delimiter.</p> <p>The default Enclosed By by characters are a double quotation marks (" "). The default delimiter is either a comma or a semicolon depending upon your current NLS settings.</p> </li> <li> <p>In the Link Label field, enter link text. This text will display in your report and enable users to invoke a download.</p> </li> <li> <p>(Optional) To specify a default export file name, enter a name in the Filename field.</p> <p>By default, the Application Express engine creates an export file name by taking the region name and adding the appropriate file name extension (<code>.csv</code> or <code>.xml</code>).</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="CEGFEEEJ" name="CEGFEEEJ"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB05023|report, export"></a>Exporting a Classic Report as an XML File or a CSV File</h2> <p>You <a id="sthref998" name="sthref998"></a>can export a report as an XML file by selecting a report template.</p> <p>To export a report as a file:</p> <ol> <li> <p>Navigate to the appropriate Report Attributes page. See <a href="#BCEIEEDJ">"Editing SQL and Wizard Reports"</a>.</p> </li> <li> <p>Scroll down to Layout and Pagination.</p> </li> <li> <p>From the Report Template list, select <span class="bold">export: XML</span> or <span class="bold">export: CSV</span>.</p> <p>Selecting <span class="bold">export: XML</span> prevents the Application Express engine from rendering the page and dumps the content to an XML file.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="BCECBBGH" name="BCECBBGH"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB05024|report, column link"></a>Creating a Column <a id="sthref999" name="sthref999"></a>Link in a Classic Report</h2> <p>Use the Column Link attributes to create a link from a report to another page in your application or to a URL.</p> <p>To create a column link to another page:</p> <ol> <li> <p>Navigate to the appropriate Report Attributes page. See <a href="#BCEIEEDJ">"Editing SQL and Wizard Reports"</a>.</p> </li> <li> <p>Under Column Attributes, locate the column to contain the link.</p> </li> <li> <p>Click the <span class="bold">Edit</span> icon next to the column name.</p> <p>The Column Attributes page appears.</p> </li> <li> <p>Scroll down to Column Link.</p> </li> <li> <p>To create a column link to another page:</p> <ol> <li> <p>From Target, select <span class="bold">Page in this Application</span>.</p> </li> <li> <p>(Optional) In Link Attributes, specify additional column link attributes to be included in the <code><a href= ></code> tag (for example, a link target, classes, or styles).</p> </li> <li> <p>In Link Text, enter the text to be displayed as a link, specify an image tag, or pick from the list of default images.</p> </li> <li> <p>In Page, specify the target page number. To reset the pagination for this page, select <span class="bold">Reset Pagination</span>.</p> </li> <li> <p>In Request, specify the request to be used.</p> </li> <li> <p>In Clear Cache, specify the pages (that is, the page numbers) on which to clear cache. You can specify multiple pages by listing the page numbers in a comma-delimited list.</p> </li> <li> <p>Use the Name and Value fields to specify session state for a specific item.</p> </li> </ol> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> <p>To create a column link to a URL:</p> <ol> <li> <p>Navigate to the appropriate Report Attributes page. See <a href="#BCEIEEDJ">"Editing SQL and Wizard Reports"</a>.</p> </li> <li> <p>Access the Column Attributes page by clicking the <span class="bold">Edit</span> icon next to the appropriate column.</p> <p>The Column Attributes page appears.</p> </li> <li> <p>Scroll down to Column Link.</p> </li> <li> <p>Under Column Link, specify the following:</p> <ol> <li> <p>From Target Type, select <span class="bold">URL</span>.</p> </li> <li> <p>In Link Text, enter the text to be displayed as a link and select a substitution string.</p> </li> <li> <p>(Optional) In Link Attributes, specify additional column link attributes to be included in the <code><a href= ></code> tag (for example, a link target, classes, or styles).</p> </li> <li> <p>In URL, enter the appropriate address.</p> </li> </ol> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="BCEDBJFH" name="BCEDBJFH"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB05025|report, updatable column"></a>Defining an Updatable <a id="sthref1000" name="sthref1000"></a>Column in a Classic Report</h2> <p>You can make a column updatable by editing Tabular Form Element attributes on the Column Attributes page. Note that the Application Express engine can only perform updates if:</p> <ul> <li> <p>A multirow update is defined</p> </li> <li> <p>A PL/SQL process is implemented to process updated data</p> </li> <li> <p>When using the built-in tabular form elements and display types, then the report has to be defined using the type <span class="bold">SQL Query (updatable report)</span></p> </li> </ul> <p>To define updatable column attributes:</p> <ol> <li> <p>Navigate to the appropriate Report Attributes page. See <a href="#BCEIEEDJ">"Editing SQL and Wizard Reports"</a>.</p> </li> <li> <p>Access the Column Attributes page by clicking the <span class="bold">Edit</span> icon next to the appropriate column.</p> <p>The Column Attributes page appears.</p> </li> <li> <p>Scroll down to Tabular Form Element.</p> </li> <li> <p>Under Tabular Form Element, specify the following:</p> <ol> <li> <p>Display As - Select a type of updatable column.</p> <p>Use this option to make a column updatable. Updates can only be performed if a multirow update is defined, or a PL/SQL process is implemented to process updated data.</p> </li> <li> <p>Date Picker Format Mask - Make a selection if you selected the Display As type of <span class="bold">Date Picker</span>.</p> </li> <li> <p>Element Width - Specify the width of the form item.</p> </li> <li> <p>Number of Rows - Specify the height of a form item (applicable to text areas).</p> </li> <li> <p>Element Attributes - Define a style or standard form element attribute.</p> </li> <li> <p>Element Option Attributes - Specify form element attributes for items in a radio group or check box.</p> </li> <li> <p>Primary Key Source Type - Identify the default type.</p> </li> <li> <p>Primary Key Source - Identify the default source.</p> <p>If the current column is part of the primary key defined in an MRU process, only the primary key source type and source appear.</p> <p>Otherwise, Default and Default Type appear. Use Default and Default Type to establish a relationship between two master records in a master detail form, or to set the default values for new rows.</p> </li> <li> <p>Reference Table Owner - Identify the owner of the referenced table. Use this attribute to build User Interface Defaults for reports.</p> </li> <li> <p>Reference Table Name - Identify the table or view that contains the current report column.</p> </li> <li> <p>Reference Column Name - Identify the column name that this report column references.</p> </li> </ol> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="BCECDBCB" name="BCECDBCB"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB05026|report, column as list of value"></a>Defining a Column as a List of <a id="sthref1001" name="sthref1001"></a>Values in a Classic Report</h2> <p>Report columns can be rendered as lists of values. For example, a column can be rendered using a select list or a popup list of values. Or, a column can be rendered as read-only text based on a list of values.</p> <p>This last approach is an effective strategy when creating display lookup values and is particularly useful in regular, nonupdatable reports. This approach enables you to display the value of a column without having to write a SQL JOIN statement.</p> <p>To render a report column as a list of values:</p> <ol> <li> <p>Navigate to the appropriate Report Attributes page. See <a href="#BCEIEEDJ">"Editing SQL and Wizard Reports"</a>.</p> </li> <li> <p>Access the Column Attributes page by clicking the <span class="bold">Edit</span> icon next to the appropriate column.</p> <p>The Column Attributes page appears.</p> </li> <li> <p>Scroll down to List of Values.</p> </li> <li> <p>From Named LOV, make a selection from the List of Values repository. See <a href="bldapp_lov.htm#CHDFGFHI">"Creating Lists of Values"</a>.</p> </li> <li> <p>To include a null value in a list of values:</p> <ol> <li> <p>In Display Null, select <span class="bold">Yes</span>.</p> </li> <li> <p>In Null Text, specify the value that displays.</p> </li> </ol> <p>A column can also have a value that does not display in its list of values.</p> </li> <li> <p>To define a value that does not display in the list of values:</p> <ol> <li> <p>From Display Extra Value, select <span class="bold">Yes</span>.</p> <p>The extra value is used if the actual column value is not part of the LOV. In that situation, the actual value is shown. If you do not display extra values, you may end up with the wrong value and unintentionally update your data incorrectly.</p> </li> <li> <p>In Null Value, specify the value that displays.</p> </li> <li> <p>If you have not selected a Named LOV, enter the query used to display a select list in the LOV Query field.</p> </li> </ol> </li> <li> <p>If you have not selected a Named LOV, enter the query used to display a select list in LOV Query.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Tutorials:</p> "How to Create a Tabular Form" in <span class="italic"><a href="http://www.oracle.com/pls/db112/lookup?id=HTMAD001">Oracle Application Express Advanced Tutorials</a></span></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="BCEBDIFA" name="BCEBDIFA"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB05027|report, column display"></a>Controlling When Columns <a id="sthref1002" name="sthref1002"></a>Display in a Classic Report</h2> <p>You can use the Authorization and Condition attributes to control when a column displays.</p> <p>Authorization enables you to control access to resources (such as a report column) based on predefined user privileges. For example, you could create an authorization scheme in which only managers can view a specific report column. Before you can select an authorization scheme, you must first create it.</p> <p>A condition is a small unit of logic that enables you to control the display of a column based on a predefined condition type. The condition evaluates to true or false based on the values you enter in the Expressions fields.</p> <p>To specify Authorization and Condition attributes:</p> <ol> <li> <p>Navigate to the appropriate Report Attributes page. See <a href="#BCEIEEDJ">"Editing SQL and Wizard Reports"</a>.</p> </li> <li> <p>Access the Column Attributes page by clicking the <span class="bold">Edit</span> icon next to the appropriate column.</p> <p>The Column Attributes page appears.</p> </li> <li> <p>Under Authorization, make a selection from the Authorization Scheme list.</p> </li> <li> <p>Under Conditions, make a selection from the Condition Type list, and depending upon your selection, enter an expression or value in the appropriate Expression fields.</p> <p>If the authorization is successful and the condition type display evaluates to true, the column displays.</p> </li> </ol> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="sec_authorization.htm#BABEDFGB">"Providing Security Through Authorization"</a>, <a href="concept_cond_process.htm#BEIEBEHI">"Understanding Conditional Rendering and Processing"</a>, and <a href="condition.htm#CJHJFDBA">Available Conditions</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="BCEDBBBJ" name="BCEDBBBJ"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB05028|report, column breaks"></a>Controlling Column <a id="sthref1003" name="sthref1003"></a>Breaks in a Classic Report</h2> <p>You can control if a specific column repeats and how column breaks appear when printed using Break Formatting attributes. For example, suppose your report displays employee information by department number. If multiple employees are members of the same department, you can increase the readability by specifying the department number only appears once.</p> <p>To create this type of column break:</p> <ol> <li> <p>Navigate to the appropriate Report Attributes page. See <a href="#BCEIEEDJ">"Editing SQL and Wizard Reports"</a>.</p> </li> <li> <p>Scroll down to Break Formatting.</p> </li> <li> <p>Make a selection from the Breaks list.</p> </li> </ol> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <!-- 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="bldapp_rpt_create.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_rpt_int.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