Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\bldapp_rpt_int.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 Interactive 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 Interactive 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_int.htm" title="Editing Interactive Reports" type="text/html" /> <link rel="prev" href="bldapp_rpt_att.htm" title="Previous" type="text/html" /> <link rel="next" href="bldapp_rpt_print.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 Interactive 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_att.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_rpt_print.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDEFABF" name="CHDEFABF"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB25353" id="HTMDB25353"></a>Editing Interactive <a id="sthref1004" name="sthref1004"></a>Reports</h1> <p>Interactive reports enable end users to alter the layout of report data by choosing the columns they are interested in, applying filters, highlighting, and sorting. They can also define breaks, aggregations, create charts, and their define their own computations. Users can create multiple variations of the report and save them as named reports and download to various file formats including comma-delimited file (CSV) format, Microsoft Excel (XLS) format, Adobe Portable Document Format (PDF), and Microsoft Word Rich Text Format (RTF).</p> <a id="sthref1005" name="sthref1005"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="#BABCAAIA">Accessing the Interactive Report Attributes Page</a></p> </li> <li> <p><a href="#BABDGGCG">Editing Interactive Report Column Attributes</a></p> </li> <li> <p><a href="#BABJJBHE">Creating Column Groups</a></p> </li> <li> <p><a href="#BABICHIF">Controlling Interactive Report Pagination</a></p> </li> <li> <p><a href="#BABDICIH">Managing Interactive Report Column Sorting</a></p> </li> <li> <p><a href="#BABDCABG">Including a Search Bar in an Interactive Report</a></p> </li> <li> <p><a href="#BABCCGFF">Adding a Download Option to the Actions Menu</a></p> </li> <li> <p><a href="#BABDAEFJ">About the Link Column</a></p> </li> <li> <p><a href="#BABEAFDA">Creating a Column Link in an Interactive Report</a></p> </li> <li> <p><a href="#BABDBDGE">Defining a Column as a List of Values in an Interactive Report</a></p> </li> <li> <p><a href="#BABCIHII">Saving Default Report Settings</a></p> </li> <li> <p><a href="#BABEIGAG">Saving a Named Interactive Report</a></p> </li> <li> <p><a href="#BABEEABE">Configuring Advanced Attributes for Interactive Reports</a></p> </li> <li> <p><a href="#BABDHIDJ">Linking to Interactive Reports</a></p> </li> </ul> <a id="BABCAAIA" name="BABCAAIA"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25354" id="HTMDB25354"></a>Accessing the Interactive Report <a id="sthref1006" name="sthref1006"></a>Attributes Page</h2> <p>You can access the Interactive Report Attributes page by clicking the <span class="bold">Interactive 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/int_rprt_att.gif" alt="Description of int_rprt_att.gif follows" title="Description of int_rprt_att.gif follows" longdesc="img_text/int_rprt_att.htm" /><br /> <a id="sthref1007" name="sthref1007" href="img_text/int_rprt_att.htm">Description of the illustration int_rprt_att.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">Interactive 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="#BABDGGCG">"Editing Interactive Report Column Attributes"</a>.</p> </li> <li> <p><span class="bold">Column Groups</span> attributes enable you to group columns together on the single row view. See <a href="#BABJJBHE">"Creating Column Groups"</a>.</p> </li> <li> <p><span class="bold">Pagination</span> attributes control report pagination. See <a href="#BABICHIF">"Controlling Interactive 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="#BABDICIH">"Managing Interactive Report Column Sorting"</a>.</p> </li> <li> <p><span class="bold">Search Bar</span> contain attributes that enable you to define a search bar within an interactive report. See <a href="#BABDCABG">"Including a Search Bar in an Interactive Report"</a>.</p> </li> <li> <p><span class="bold">Download</span> enables you to add a download option to the Actions menu and export the report as CSV, XLS, PDF, or RTF file. See <a href="#BABCCGFF">"Adding a Download Option to the Actions Menu"</a>.</p> </li> <li> <p><span class="bold">Link Column</span> attributes enable you to add a link to a column. See <a href="#BABEAFDA">"Creating a Column Link in an Interactive Report"</a>.</p> </li> <li> <p><span class="bold">Advanced Attributes</span> enable you to define a report alias, send a user a saved view of a report, show saved reports as tabs, prevent execution of queries that take a specified amount of time to execute, and define items to set into session state. See <a href="#BABEEABE">"Configuring Advanced Attributes for Interactive Reports"</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> </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="bldapp_rpt_att.htm#BCECBBGH">"Creating a Column Link in a Classic Report"</a> and <a href="bldapp_rpt_att.htm#BCEDBJFH">"Defining an Updatable Column in a Classic Report"</a>, and <a href="bldapp_rpt_att.htm#BCECDBCB">"Defining a Column as a List of Values in a Classic Report"</a>, and <a href="bldapp_rpt_att.htm#BCEBDIFA">"Controlling When Columns Display in a Classic Report"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <div class="sect4"><!-- infolevel="all" infotype="General" --><a id="sthref1008" name="sthref1008"></a> <h3><a name="HTMDB25355" id="HTMDB25355"></a>About Navigation Alternatives</h3> <p>The Report Attribute page is divided into these sections: Column Attributes, Groups, Defaut Report, Pagination, Sorting, Search Bar, Download, Link Column, Advanced, and Description.</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="sthref1009" name="sthref1009" 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="BABDGGCG" name="BABDGGCG"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25356" id="HTMDB25356"></a>Editing Interactive Report <a id="sthref1010" name="sthref1010"></a>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, or hide a column.</p> <p>To access 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">Interactive Report</span> next to the name of the report region you want to edit.</p> <p>The Interactive Report Attributes page appears with the Column Attributes section at the top of the page.</p> <img src="img/int_rprt_col.gif" alt="Description of int_rprt_col.gif follows" title="Description of int_rprt_col.gif follows" longdesc="img_text/int_rprt_col.htm" /><br /> <a id="sthref1011" name="sthref1011" href="img_text/int_rprt_col.htm">Description of the illustration int_rprt_col.gif</a><br /> <br /> <p>Use the Column Attributes section to control report column appearance and functionality.</p> <p><span class="bold">Heading</span> displays the heading text to be included in the report. <span class="bold">Type</span> indicates the type of query column. The <span class="bold">Link</span> column indicates if a column link is currently defined.</p> <p><a href="#BABHCCIF">Table: Common Report Column Edits for Interactive Reports</a> describes common report column edits.</p> <div class="tblformal"><a id="sthref1012" name="sthref1012"></a><a id="BABHCCIF" name="BABHCCIF"></a> <p class="titleintable">Common Report Column Edits for Interactive Reports</p> <table class="Formal" title="Common Report Column Edits for Interactive 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="40%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t15">Description</th> <th align="left" valign="bottom" id="r1c2-t15">Developer Action</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t15" headers="r1c1-t15"> <p>Alter column display sequence.</p> </td> <td align="left" headers="r2c1-t15 r1c2-t15"> <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-t15" headers="r1c1-t15"> <p>Change column group assignment.</p> </td> <td align="left" headers="r3c1-t15 r1c2-t15"> <p>If Column Groups are defined, individual columns can be assigned under Column Group.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t15" headers="r1c1-t15"> <p>Change column heading text.</p> </td> <td align="left" headers="r4c1-t15 r1c2-t15"> <p>Under Heading, enter different heading text.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t15" headers="r1c1-t15"> <p>Change how columns display.</p> </td> <td align="left" headers="r5c1-t15 r1c2-t15"> <p>Select an option from Display Text As.</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>You can control whether users can sort, filter, control breaks, aggregate, and create computations or chart, by selecting the appropriate check boxes under Allow Users To.</p> </li> <li> <p>Under Column Definition, Allow Users To, select the appropriate check box.</p> <p>To learn more about a specific attribute, click the item label.</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="bldapp_rpt_att.htm#BCECBBGH">"Creating a Column Link in a Classic Report"</a> and <a href="bldapp_rpt_att.htm#BCEDBJFH">"Defining an Updatable Column in a Classic Report"</a>, and <a href="bldapp_rpt_att.htm#BCECDBCB">"Defining a Column as a List of Values in a Classic Report"</a>, and <a href="bldapp_rpt_att.htm#BCEBDIFA">"Controlling When Columns Display in a Classic Report"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="BABJJBHE" name="BABJJBHE"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25357" id="HTMDB25357"></a>Creating Column <a id="sthref1013" name="sthref1013"></a>Groups</h2> <p>Use column groups to group columns together on a single row view.</p> <p>To create a column group:</p> <ol> <li> <p>Navigate to the Interactive Report Attributes page. See <a href="#BABCAAIA">"Accessing the Interactive Report Attributes Page"</a>.</p> <p>The Interactive Report Attributes page appears.</p> </li> <li> <p>Scroll down to Column Groups.</p> </li> <li> <p>Click <span class="bold">Add Group</span>.</p> </li> <li> <p>Under Column Group:</p> <ol> <li> <p>Sequence - Enter the display sequence for this column group. This attribute determines the order in which the column groups display in the detail view.</p> </li> <li> <p>Group Name - Enter a column group name. This name displays in the region header in detailed view.</p> </li> <li> <p>Description - Enter an optional description for the column group. This description never displays to the end user.</p> </li> </ol> </li> <li> <p>Click <span class="bold">Create</span>.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="BABICHIF" name="BABICHIF"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25358" id="HTMDB25358"></a>Controlling Interactive Report <a id="sthref1014" name="sthref1014"></a><a id="sthref1015" name="sthref1015"></a>Pagination</h2> <p>You control how pagination displays by making selections from Pagination attributes on the Interactive Report Attributes page.</p> <p>To access the Pagination section of the Report Attributes page:</p> <ol> <li> <p>Navigate to the Interactive Report Attributes page. See <a href="#BABCAAIA">"Accessing the Interactive Report Attributes Page"</a>.</p> <p>The Interactive Report Attributes page appears.</p> </li> <li> <p>Scroll down to Pagination.</p> <p>You use the Pagination attributes to select a pagination style, determine where pagination occurs, specify the maximum number of rows to query, and messages to display when more than the maximum number of rows are returned or if no rows are returned. <a href="#BABJJAAD">Table: Pagination Attributes</a> describes the available Pagination attributes.</p> </li> </ol> <div class="tblformal"><a id="sthref1016" name="sthref1016"></a><a id="BABJJAAD" name="BABJJAAD"></a> <p class="titleintable">Pagination Attributes</p> <table class="Formal" title="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-t17">Attribute</th> <th align="left" valign="bottom" id="r1c2-t17">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t17" headers="r1c1-t17"> <p>Pagination Type</p> </td> <td align="left" headers="r2c1-t17 r1c2-t17"> <p>Select a pagination type. Pagination provides the user with information about the number of rows and the current position within the result set. Pagination can be displayed above or below the report (or both) and can be positioned on the left or right. Available pagination options include:</p> <ul> <li> <p>Row Ranges X to Y</p> </li> <li> <p>Row Ranges X to Y of Z</p> </li> </ul> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t17" headers="r1c1-t17"> <p>Pagination Display Position</p> </td> <td align="left" headers="r3c1-t17 r1c2-t17"> <p>Defines where pagination occurs. Pagination can be display on the left side, right side, at the bottom, or above the report.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t17" headers="r1c1-t17"> <p>Show Null Values as</p> </td> <td align="left" headers="r4c1-t17 r1c2-t17"> <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-t17" headers="r1c1-t17"> <p>Maximum Row Count</p> </td> <td align="left" headers="r5c1-t17 r1c2-t17"> <p>Defines the maximum number of rows to query, for example, rows 1 - 10 or 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="r6c1-t17" headers="r1c1-t17"> <p>When more than maximum row data found message</p> </td> <td align="left" headers="r6c1-t17 r1c2-t17"> <p>Defines the text message that displays when more than maximum row count are returned.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t17" headers="r1c1-t17"> <p>When No Data Found Message</p> </td> <td align="left" headers="r7c1-t17 r1c2-t17"> <p>Defines the text message that displays when the query does not return any rows.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect3" --> <a id="BABDICIH" name="BABDICIH"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25359" id="HTMDB25359"></a>Managing Interactive Report Column <a id="sthref1017" name="sthref1017"></a>Sorting</h2> <p>You manage column sorting on the Interactive Report Attributes page.</p> <p>To manage column sorting:</p> <ol> <li> <p>Navigate to the Interactive Report Attributes page. See <a href="#BABCAAIA">"Accessing the Interactive Report Attributes Page"</a>.</p> <p>The Interactive Report Attributes page appears.</p> </li> <li> <p>Under Column Attributes, click the <span class="bold">Edit</span> icon for the column for which you want to enable sorting.</p> </li> <li> <p>Under Column Definition, select <span class="bold">Sort</span> and click <span class="bold">Apply Changes</span>.</p> <p>The Interactive Report Attributes page appears.</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> </ol> </div> <!-- class="sect3" --> <a id="BABDCABG" name="BABDCABG"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25360" id="HTMDB25360"></a>Including a Search Bar in an Interactive Report</h2> <p>Search bars display above the report.</p> <img src="img/search_bar.gif" alt="Description of search_bar.gif follows" title="Description of search_bar.gif follows" longdesc="img_text/search_bar.htm" /><br /> <a id="sthref1018" name="sthref1018" href="img_text/search_bar.htm">Description of the illustration search_bar.gif</a><br /> <br /> <p>To include a search bar in your report:</p> <ol> <li> <p>Navigate to the Interactive Report Attributes page. See <a href="#BABCAAIA">"Accessing the Interactive Report Attributes Page"</a>.</p> <p>The Interactive Report Attributes page appears.</p> </li> <li> <p>Scroll down to Search Bar.</p> </li> <li> <p>For Include Search Bar, select <span class="bold">Yes</span> or <span class="bold">No</span>. If you select Yes, select additional functionality to include:</p> <ul> <li> <p>Search Field - Displays a text field in the search bar in which to enter search criteria.</p> </li> <li> <p>Finder Drop Down - Enables users to search on a selected column or against all columns.</p> </li> <li> <p>Rows Per Page Selector - Displays a select list to enable users to select the number of rows to display per page.</p> </li> <li> <p>Actions Menu - Enables the user to customize the report based on selected Actions menus.</p> </li> </ul> </li> <li> <p>If you select Actions Menu, select the Action functions to include.</p> </li> <li> <p>For Button Template, select a template for buttons that display in the search region and in the dialogs.</p> </li> <li> <p>For Finder Image, specify an image. If no image is defined, <code>#IMAGE_PREFIX#/htmldb/builder/builder_find.png</code> is used.</p> </li> <li> <p>For Actions Menu Image, specify an image. If no image is defined, <code>#IMAGE_PREFIX#/ws/action_dropdown.gif</code> is used.</p> </li> <li> <p>For Search Button Label, enter the text to be used as the search button label.</p> </li> <li> <p>For Maximum Rows Per Page, enter the maximum number to display in the Rows Per Page Selector in the search bar.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="BABCCGFF" name="BABCCGFF"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25361" id="HTMDB25361"></a>Adding a Download Option to the <a id="sthref1019" name="sthref1019"></a><a id="sthref1020" name="sthref1020"></a>Actions Menu</h2> <p>You can add a Download option to the Action menu to enable users to export an interactive report as a comma-delimited file (CSV) format, Microsoft Excel (XLS) format, Adobe Portable Document Format (PDF), and Microsoft Word Rich Text Format (RTF).</p> <img src="img/download.gif" alt="Description of download.gif follows" title="Description of download.gif follows" longdesc="img_text/download.htm" /><br /> <a id="sthref1021" name="sthref1021" href="img_text/download.htm">Description of the illustration download.gif</a><br /> <br /> <p>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> <p>To enable the Enable CSV output option:</p> <ol> <li> <p>Navigate to the Interactive Report Attributes page. See <a href="#BABCAAIA">"Accessing the Interactive Report Attributes Page"</a>.</p> <p>The Interactive Report Attributes page appears.</p> </li> <li> <p>Scroll down to Download.</p> </li> <li> <p>From Download Formats, select from the following:</p> <ul> <li> <p>CSV - Comma-delimited file (CSV) file format</p> </li> <li> <p>XLS - Microsoft Excel (XLS) format</p> </li> <li> <p>PDF - Adobe Portable Document Format (PDF)</p> </li> <li> <p>RTF - Microsoft Word Rich Text Format (RTF)</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> The Download option will not display in the Actions menu if no file formats are selected</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </li> </ul> </li> <li> <p>(Optional) In the CSV Separator, define the column separator. If no value is entered, a comma or semicolon is used depending on your current NLS settings.</p> </li> <li> <p>(Optional) In the CSV Enclosed By, enter delimiter character. This character is used to delineate the starting and ending boundary of a data value. Default delimiter is double quotation marks (" ").</p> </li> <li> <p>In Filename, enter a name for the downloaded document. Do not specify a file extension, the extension is added automatically. If you leave this blank, the region name is used as the file name.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="BABDAEFJ" name="BABDAEFJ"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25362" id="HTMDB25362"></a>About the <a id="sthref1022" name="sthref1022"></a><a id="sthref1023" name="sthref1023"></a>Link Column</h2> <p>A Link Column displays on the left side of an interactive report. It can link to a single row view, a custom target, or be excluded from the report. Note that a Link Column cannot be sorted, hidden, or moved by an end user and does not interact with standard column link defined on the Column Attributes page.</p> <div class="sect4"><!-- infolevel="all" infotype="General" --><a id="sthref1024" name="sthref1024"></a> <h3><a name="HTMDB25363" id="HTMDB25363"></a>Linking to a Single Row <a id="sthref1025" name="sthref1025"></a>View</h3> <p>To link to a single row view:</p> <ol> <li> <p>Navigate to the Interactive Report Attributes page. See <a href="#BABCAAIA">"Accessing the Interactive Report Attributes Page"</a>.</p> <p>The Interactive Report Attributes page appears.</p> </li> <li> <p>Scroll down to Link Column.</p> </li> <li> <p>For Link Column, select <span class="bold">Link to Single Row View</span>.</p> </li> <li> <p>From Single Row View, select the appropriate options:</p> <ul> <li> <p><span class="bold">Allow Exclude Null Values</span> - Excludes columns with null values.</p> </li> <li> <p><span class="bold">Allow Displayed Columns</span> - Displays only the columns shown in the report.</p> </li> </ul> </li> <li> <p>For Uniquely Identify Rows by, select <span class="bold">ROWID</span> or <span class="bold">Unique Column</span>.</p> <p>If you select, <span class="bold">Unique Column</span>, specify the column in the Unique Column field.</p> </li> <li> <p>For Link Icon, select an icon.</p> </li> <li> <p>For Link Attributes (Optional), 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>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </div> <!-- class="sect4" --> <div class="sect4"><!-- infolevel="all" infotype="General" --><a id="sthref1026" name="sthref1026"></a> <h3><a name="HTMDB25364" id="HTMDB25364"></a>Linking to a <a id="sthref1027" name="sthref1027"></a>Specific Page</h3> <p>To link to a specific page:</p> <ol> <li> <p>Navigate to the Interactive Report Attributes page. See <a href="#BABCAAIA">"Accessing the Interactive Report Attributes Page"</a>.</p> <p>The Interactive Report Attributes page appears.</p> </li> <li> <p>Scroll down to Link Column.</p> </li> <li> <p>For Link Column, select <span class="bold">Link to Custom Target</span>.</p> </li> <li> <p>For Link Icon, select an icon.</p> </li> <li> <p>For Link Attributes (Optional), 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>For Target, select <span class="bold">Page in this Application</span>.</p> </li> <li> <p>For Page, select the target page number. To reset the pagination for this page, select <span class="bold">Reset Pagination</span>.</p> </li> <li> <p>For Request, specify the request to be used.</p> </li> <li> <p>For 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>For Name and Value, specify session state for a specific item.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </div> <!-- class="sect4" --> <div class="sect4"><!-- infolevel="all" infotype="General" --><a id="sthref1028" name="sthref1028"></a> <h3><a name="HTMDB25365" id="HTMDB25365"></a>Linking to a<a id="sthref1029" name="sthref1029"></a> URL</h3> <p>To link to a URL:</p> <ol> <li> <p>Navigate to the Interactive Report Attributes page. See <a href="#BABCAAIA">"Accessing the Interactive Report Attributes Page"</a>.</p> <p>The Interactive Report Attributes page appears.</p> </li> <li> <p>Scroll down to Link Column.</p> </li> <li> <p>For Link Column, select <span class="bold">Link to Custom Target</span>.</p> </li> <li> <p>For Link Icon, select an icon.</p> </li> <li> <p>For Link Attributes (Optional), specify additional column link attributes that to be included in the <code><a href= ></code> tag (for example, a link target, classes, or styles).</p> </li> <li> <p>From Target Type, select <span class="bold">URL</span>.</p> </li> <li> <p>For Target, select <span class="bold">Page in this Application</span>.</p> </li> <li> <p>In URL, enter the appropriate address.</p> </li> <li> <p>For Checksum - Select one of the following:</p> <ul> <li> <p>Use default</p> </li> <li> <p>Application Level - Link reusable by any user</p> </li> <li> <p>User Level - Link reusable by current user</p> </li> </ul> <p>To learn more about each option, see item Help.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </div> <!-- class="sect4" --> <div class="sect4"><!-- infolevel="all" infotype="General" --><a id="sthref1030" name="sthref1030"></a> <h3><a name="HTMDB25366" id="HTMDB25366"></a>Excluding a Link <a id="sthref1031" name="sthref1031"></a>Column</h3> <p>To exclude a column link:</p> <ol> <li> <p>Navigate to the Interactive Report Attributes page. See <a href="#BABCAAIA">"Accessing the Interactive Report Attributes Page"</a>.</p> <p>The Interactive Report Attributes page appears.</p> </li> <li> <p>Scroll down to Link Column.</p> </li> <li> <p>For Link Column, select <span class="bold">Exclude Link Column</span>.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </div> <!-- class="sect4" --></div> <!-- class="sect3" --> <a id="BABEAFDA" name="BABEAFDA"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25367" id="HTMDB25367"></a>Creating a Column <a id="sthref1032" name="sthref1032"></a>Link in an Interactive Report</h2> <p>Column 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 Interactive Report Attributes page. See <a href="#BABCAAIA">"Accessing the Interactive Report Attributes Page"</a>.</p> <p>The Interactive Report Attributes page appears.</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 Interactive Report Attributes page. See <a href="#BABCAAIA">"Accessing the Interactive Report Attributes Page"</a>.</p> <p>The Interactive Report Attributes page appears.</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="BABDBDGE" name="BABDBDGE"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25368" id="HTMDB25368"></a>Defining a Column as a List of <a id="sthref1033" name="sthref1033"></a>Values in an Interactive Report</h2> <p>In interactive reports you can use a list of values to improve the speed of built-in filter tools.</p> <p>To define a report column as a list of values:</p> <ol> <li> <p>Navigate to the Interactive Report Attributes page. See <a href="#BABCAAIA">"Accessing the Interactive Report Attributes Page"</a>.</p> <p>The Interactive Report Attributes page appears.</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 Column Filter List of Values, specify how to create a list of values as a filter on the report column list. Available options include:</p> <ul> <li> <p><span class="bold">None</span> - Disable filter on list of values.</p> </li> <li> <p><span class="bold">Default Based on Column Type</span> - <code>STRING</code> and <code>NUMBER</code> columns derive list of values from distinct column values. <code>DATE</code> columns derive list of values from predefined date ranges.</p> </li> <li> <p><span class="bold">Use Defined List of Values</span> - Derive list of values from defined list of values SQL Query.</p> </li> <li> <p>List of values definition - If you select <span class="bold">Use Defined List of Values</span>, enter a SQL query that selects the distinct column values. Entering a SQL query can improve performance in some reports. This list of values will be displayed when a user clicks on a column header.</p> </li> </ul> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="BABCIHII" name="BABCIHII"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25369" id="HTMDB25369"></a>Saving Default Report Settings</h2> <p>Default report settings determine the way a report initially displays to end users. End users can then modify any of the settings (that you allow them to change).</p> <p>To create default report settings:</p> <ol> <li> <p>Run the report as a developer.</p> </li> <li> <p>From the Actions menu, modify the settings (for example, hide columns, add filters, and so on.)</p> <img src="img/int_rprt_settings.gif" alt="Description of int_rprt_settings.gif follows" title="Description of int_rprt_settings.gif follows" longdesc="img_text/int_rprt_settings.htm" /><br /> <a id="sthref1034" name="sthref1034" href="img_text/int_rprt_settings.htm">Description of the illustration int_rprt_settings.gif</a><br /> <br /></li> <li> <p>From the Actions menu, select <span class="bold">Save Report</span>.</p> </li> <li> <p>In Save Report:</p> <ol> <li> <p>Save - Select <span class="bold">As Default Report Settings.</span></p> </li> <li> <p>Click <span class="bold">Apply</span>.</p> </li> </ol> </li> </ol> </div> <!-- class="sect3" --> <a id="BABEIGAG" name="BABEIGAG"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25370" id="HTMDB25370"></a>Saving a Named Interactive <a id="sthref1035" name="sthref1035"></a>Report</h2> <p>To save an interactive report as a named report:</p> <ol> <li> <p>Run the report.</p> </li> <li> <p>From the Actions menu, select <span class="bold">Save Report</span>.</p> </li> <li> <p>In Save Report:</p> <ol> <li> <p>Save - Select <span class="bold">As Named Report.</span></p> </li> <li> <p>Name - Enter a name for the report.</p> </li> <li> <p>Description - Enter an optional description.</p> </li> <li> <p>Click <span class="bold">Apply</span>.</p> </li> </ol> </li> </ol> </div> <!-- class="sect3" --> <a id="BABEEABE" name="BABEEABE"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25371" id="HTMDB25371"></a>Configuring Advanced Attributes for<a id="sthref1036" name="sthref1036"></a> Interactive Reports</h2> <p>Use the Advanced Attributes section to define a report alias, send a user a saved view of a report, show saved reports as tabs, prevent execution of queries that take a specified amount of time to execute, and define items to set into session state</p> <p>To configure Advanced Attributes:</p> <ol> <li> <p>Navigate to the Interactive Report Attributes page. See <a href="#BABCAAIA">"Accessing the Interactive Report Attributes Page"</a>.</p> <p>The Interactive Report Attributes page appears.</p> </li> <li> <p>Scroll down to Advanced Attributes.</p> <p><a href="#BABEIJAJ">Table: Advanced Attributes</a> describes the available Advanced Attributes.</p> </li> </ol> <div class="tblformal"><a id="sthref1037" name="sthref1037"></a><a id="BABEIJAJ" name="BABEIJAJ"></a> <p class="titleintable">Advanced Attributes</p> <table class="Formal" title="Advanced Attributes" summary="This table describes Advanced 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-t20">Attribute</th> <th align="left" valign="bottom" id="r1c2-t20">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t20" headers="r1c1-t20"> <p>Report Alias</p> </td> <td align="left" headers="r2c1-t20 r1c2-t20"> <p>Enter an alphanumeric alias for this interactive report. You may use an alias to reference an interactive report in an API call (for example, to change the columns displayed). The alias must be unique within the application.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t20" headers="r1c1-t20"> <p>Report ID Item</p> </td> <td align="left" headers="r3c1-t20 r1c2-t20"> <p>This attribute enables you to send a user directly to a saved view of the report that they have saved. You specify an item whose value stores the report ID of the saved view. Report ID's can be retrieved from the <code>APEX_APPLICATION_PAGE_IR_RPT</code> view.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t20" headers="r1c1-t20"> <p>Show Saved Reports as Tabs</p> </td> <td align="left" headers="r4c1-t20 r1c2-t20"> <p>If saved versions of the report exist, this attribute specifies if they should be displayed as tabs. Turn tabs off to create a separate page with a list of reports.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t20" headers="r1c1-t20"> <p>Page Items to Submit</p> </td> <td align="left" headers="r5c1-t20 r1c2-t20"> <p>Enter a comma separated list of items to be set into session state when the user clicks the <span class="bold">Go</span> button on the search bar. Only items on the current page will be set.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect3" --> <a id="BABDHIDJ" name="BABDHIDJ"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25372" id="HTMDB25372"></a>Linking to Interactive <a id="sthref1038" name="sthref1038"></a>Reports</h2> <p>Unlike classic reports which typically use page items as report parameters, the data in an interactive report is driven by declarative filters. However, the developer may desire to set these report parameters by modifying interactive report settings for an end user. These settings only affect the end user's working report and will not affect any saved report settings.</p> <p>To reset an interactive report in a link, use the string <code>"RIR"</code> in the Clear-Cache section of a URL. This is equivalent to the end user choosing the Reset option from the interactive report actions menu on the target page. The report is returned to the default report settings specified by the developer.</p> <p>To clear settings in an interactive report in a link, use the string <code>"CIR"</code> in the Clear-Cache section of a URL. This is equivalent to the end user removing all filters, control breaks, highlights, aggregates, computed columns, chart settings, and flashback settings on the target page.</p> <p>To create a filter on an interactive report in a link, use the string <code>IR<operator>_<target column alias></code> in the Item Names section of the URL, and pass the filter value in the corresponding location in the Item Values section of the URL.</p> <p>Valid operators include:</p> <ul> <li> <p><code>EQ</code> = Equals (this is the default)</p> </li> <li> <p><code>NEQ</code> = Not Equals</p> </li> <li> <p><code>LT</code> = Less than</p> </li> <li> <p><code>LTE</code> = Less then or equal to</p> </li> <li> <p><code>GT</code> = Greater Than</p> </li> <li> <p><code>GTE</code> = Greater than or equal to</p> </li> <li> <p><code>LIKE</code> = SQL Like operator</p> </li> <li> <p><code>N</code> = Null</p> </li> <li> <p><code>NN</code> = Not Null</p> </li> <li> <p><code>C</code> = Contains</p> </li> <li> <p><code>NC</code> = Not Contains</p> </li> </ul> <p>Consider the following examples:</p> <pre xml:space="preserve" class="oac_no_warn"> f?p=...:IR_ENAME:KING </pre> <p>The previous example is equivalent to the end user creating a filter on the target page: <code>ENAME = KING</code>. Note that when an operator is not provided, <code>EQ</code> is used because it is the default.</p> <pre xml:space="preserve" class="oac_no_warn"> f?p=...:IRGT_SAL:3000 </pre> <p>The previous example is equivalent to the end user creating a filter on the target page: <code>SAL > 3000</code>.</p> </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_att.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_rpt_print.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