Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\bldapp_rpt_print.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>Printing Report Regions</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:29Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Printing Report Regions" /> <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_print.htm" title="Printing Report Regions" type="text/html" /> <link rel="prev" href="bldapp_rpt_int.htm" title="Previous" type="text/html" /> <link rel="next" href="bldapp_frm.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> > Printing Report Regions</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_int.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_frm.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CEGFBBHI" name="CEGFBBHI"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB05033|report, print attributes"></a>Printing <a id="sthref1039" name="sthref1039"></a><a id="sthref1040" name="sthref1040"></a><a id="sthref1041" name="sthref1041"></a>Report Regions</h1> <p>You can configure a classic report region to print by exporting it to a number of different formats. Oracle BI Publisher supports Adobe Portable Document Format (PDF), Microsoft Word Rich Text Format (RTF), or Microsoft Excel format (XLS), or Extensible Markup Language (XML). The supplied OC4J with Apache FOP alternative only supports PDF and XML. If you choose to use other third-party rendering engines, other output formats can also be configured.</p> <p>By taking advantage of region report printing, your application users can view and print reports that have a predefined orientation, page size, column headings, and page header and footer. Interactive reports also have the ability to export to PDF, RTF, Microsoft Excel and Comma Separated Values (CSV). Note that for interactive reports, it is not possible to define a custom report layout.</p> <a id="sthref1042" name="sthref1042"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="#BABJIGCB">About Printing Reports to PDF</a></p> </li> <li> <p><a href="#BABHBBAH">About Report Printing Configuration Options</a></p> </li> <li> <p><a href="#BABGEGJD">About Classic Report Printing Methods</a></p> </li> <li> <p><a href="#CEGDEIHF">About Report Queries</a></p> </li> <li> <p><a href="#CEGEHDJC">About Report Layouts</a></p> </li> <li> <p><a href="#CEGHEFFG">Configuring Classic Report Region Print Attributes</a></p> </li> <li> <p><a href="#BABFHBEH">Configuring Interactive Report Region Print Attributes</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">Tip:</p> If you are running Oracle Application Express with Oracle Database 11<span class="italic">g</span> Release 1 (11.1), you must enable network services in order to use report printing. See <a href="sec_network_services.htm#BGEJJIHE">"Enabling Network Services in Oracle Database 11<span class="italic">g</span>"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <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> "How to Create a Master Detail PDF Report" in <span class="italic"><a href="http://www.oracle.com/pls/db112/lookup?id=HTMAD013">Oracle Application Express Advanced Tutorials</a></span></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="BABJIGCB" name="BABJIGCB"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25373" id="HTMDB25373"></a>About Printing <a id="sthref1043" name="sthref1043"></a>Reports to PDF</h2> <p>When printing to a PDF, the report data is transformed using an externally defined report server. When the application end user clicks a print link, a request is sent to the Application Express engine. The Application Express engine then generates the report data in XML format and report template in XSL-FO or RTF format. The external reporting engine then transforms the data and the template into a PDF which displays to the end user using the conversion servlet that ships with BI Publisher 10.1.3.2 (formerly known as Oracle XML Publisher). Fortunately, this architectural complexity is transparent to both end users and developers. End users just click a print link, and developers just declaratively set regions to support PDF printing. Output to other formats operates in the same manner using the necessary conversion servlet.</p> </div> <!-- class="sect3" --> <a id="BABHBBAH" name="BABHBBAH"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25374" id="HTMDB25374"></a>About Report Printing <a id="sthref1044" name="sthref1044"></a>Configuration Options</h2> <p>Your report server can be Oracle BI Publisher, OC4J with Apache FOP, or another standard XSL-FO processing engine. Oracle BI Publisher provides a higher level of functionality and facilitates "high fidelity" output requirements including master-detail reports, charts, and so on. To accommodate the difference in functionality, Oracle Application Express provides two report printing configuration options:</p> <ul> <li> <p><span class="bold">Standard Support</span>. Enables you to print report regions and report queries using either the built-in templates (provided with a standard XSL-FO processing engine), or other XSL-FO compatible formats you provide. This setting does not support RTF.</p> <p>Standard Support provides declarative formatting of report regions and report queries with basic control over page attributes, including page orientation, page size, column heading formats, page header, and page footer.</p> </li> <li> <p><span class="bold">Advanced Support</span>. Requires a valid license of Oracle BI Publisher (also known as Oracle XML Publisher). This setting, provides you with all the capabilities of the Standard configuration plus the ability to define RTF-based report layouts developed using the BI Publisher Word Template Builder.</p> <p>To learn more about installing and configuring Oracle BI Publisher, see <a href="http://www.oracle.com/technology/products/database/application_express/html/configure_printing.html"><span class="italic">PDF Printing in Application Express 3.1</span></a>. Go to:</p> <pre xml:space="preserve" class="oac_no_warn"> <code><a href="http://www.oracle.com/technology/products/database/application_express/html/configure_printing.html">http://www.oracle.com/technology/products/database/application_express/html/configure_printing.html</a></code> </pre></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">Note:</p> To use the full functionality of report printing, your Oracle Application Express service administrator must enable it for your site. See "Configuring Report Printing" in <a href="AEADM/adm_env.htm"><span class="italic">Oracle Application Express Administration Guide</span></a>.</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="BABGEGJD" name="BABGEGJD"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25375" id="HTMDB25375"></a>About Classic Report Printing <a id="sthref1045" name="sthref1045"></a>Methods</h2> <p>There are two ways to print classic report regions:</p> <ul> <li> <p><span class="bold">Configure Printing Attributes for a Report Region.</span> You can print a report region by configuring the Printing Attributes for the region. See <a href="#CEGHEFFG">"Configuring Classic Report Region Print Attributes"</a>.</p> </li> <li> <p><span class="bold">Create a Report Query</span>. You can print a report by defining a report query as a Shared Component. See <a href="#CEGDEIHF">"About Report Queries"</a>.</p> </li> </ul> <p>Both report regions and report queries can be downloaded in the following formats:</p> <ul> <li> <p>PDF - Adobe Portable Document Format.</p> </li> <li> <p>RTF - Microsoft Word Rich Text Format.</p> </li> <li> <p>XLS - Microsoft Excel format. Note that this is not a true <code>.xls</code> file because the content is HTML-based.</p> </li> <li> <p>HTML</p> </li> <li> <p>XML - Extensible Markup Language.</p> </li> </ul> <p>To format either a report region or report query, you associate it with a report layout. To learn more, see <a href="#CEGEHDJC">"About Report Layouts"</a>.</p> </div> <!-- class="sect3" --> <a id="CEGDEIHF" name="CEGDEIHF"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25376" id="HTMDB25376"></a>About Report <a id="sthref1046" name="sthref1046"></a>Queries</h2> <p>You can print a report region by defining a report query as a Shared Component. A report query identifies the data to be extracted. Unlike SQL statements contained in regions, report queries contain SQL statements that are validated when you save the query. Note that report queries must be SQL statements, not functions returning SQL statements.</p> <p>You can associate a report query with a report layout and download it as a formatted document. If no report layout is selected, a generic layout is used. The generic layout is intended to be used to test and verify a report query. When using the generic layout option and multiple source queries are defined, only the first result set is included in the print document. The reports can include session state of the current application.</p> <p>To make these reports available to end users, you then integrate them with an application. For example, you can associate a report query with a button, list item, branch, or other navigational component that enables you to use URLs as targets. Selecting that item then initiates the printing process.</p> <a id="sthref1047" name="sthref1047"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="#BABCEBGC">Creating a Report Query</a></p> </li> <li> <p><a href="#BABFCBCA">Editing Report Queries</a></p> </li> <li> <p><a href="#BABBEHAD">Copying Report Queries</a></p> </li> </ul> <a id="BABCEBGC" name="BABCEBGC"></a> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h3><a name="HTMDB25377" id="HTMDB25377"></a>Creating a Report <a id="sthref1048" name="sthref1048"></a>Query</h3> <p>Note that the availability of the report query options depends on how your service administrator configures report printing for your instance. All options described in these steps may not be available to you.</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="#BABHBBAH">"About Report Printing Configuration Options"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <p>To create a report query:</p> <ol> <li> <p>Navigate to the Shared Components page. See <a href="bldr_sc_goto.htm#BABEEJAI">"Accessing the Shared Components Page"</a>.</p> </li> <li> <p>Under Reports, click <span class="bold">Report Queries</span>.</p> </li> <li> <p>Click <span class="bold">Create</span>.</p> </li> <li> <p>For Query, specify the following information:</p> <ol> <li> <p>Report Query Name - Enter a name to identify the report query. When referencing a report query as a link target, the report query name is part of the request string.</p> </li> <li> <p>Output Format - Select the report output format. Valid options include:</p> <ul> <li> <p>PDF - Adobe Portable Document Format.</p> </li> <li> <p>Word - Microsoft Word Rich Text Format.</p> </li> <li> <p>Excel - Microsoft Excel format. Note that this is not a true <code>.xls</code> file because the content is HTML-based.</p> </li> <li> <p>HTML</p> </li> <li> <p>XML - Extensible Markup Language.</p> </li> </ul> </li> <li> <p>Item - Select the item to hold the format value. This can be used to determine the output format at runtime.</p> </li> <li> <p>View File As - Select how the Web browser opens the report query document. Options include:</p> <ul> <li> <p><span class="bold">Attachment</span> - Displays a File Open/Save dialog box when the user clicks the report query download button.</p> </li> <li> <p><span class="bold">Inline</span> - Displays the report query document inside the Browser window.</p> </li> </ul> </li> <li> <p>Session State - Select this check box to reference session state values, such as the values of page items in the XML structure of your report.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> </li> <li> <p>For SQL Query, enter a SQL statement directly or click <span class="bold">Query Builder</span> to build a SQL statement by clicking and pointing.</p> <p>To reference applications and page items in the SQL statement, reference them as bind variables. Click <span class="bold">Set Bind Variables</span> to be able to enter in values for each bind variable and test the query to ensure the expected output is returned.</p> </li> <li> <p>For Download Definition, specify the following:</p> <ol> <li> <p>Data Source for Report Layout - Use this option to download a report definition export file. Select <span class="bold">XML Data</span> or <span class="bold">XML Schema</span> and then click <span class="bold">Download</span>.</p> <p>XML Schema creates XSD file (that is, a XML schema definition of your XML structure.)</p> </li> <li> <p>Add Query - Click this button to add another query to the report query. Adding another query enables the production of complex reports with more than one output component (for example, a chart and a report based on two different queries).</p> </li> <li> <p>Create Report Query - Click this button to exit the wizard early. The Report Layout Source will default to use the generic report layout.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> </li> <li> <p>For Upload Report Layout, specify the following:</p> <ol> <li> <p>Report Layout Source - Specify how the report layout is derived. If you choose the report based file layout then the layout name and report layout file must be provided.</p> </li> <li> <p>Layout Name - Enter a layout name (optional). The default is the report query name.</p> </li> <li> <p>Report Layout File - Click <span class="bold">Browse</span> and select a Rich Text Format (RTF).</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> </li> <li> <p>For Confirm:</p> <ol> <li> <p>Query Name - Identifies the query.</p> </li> <li> <p>Report Layout - Identifies the report layout you selected.</p> </li> <li> <p>Output Format - Identifies the format for this report query.</p> </li> <li> <p>Derive from Item - Identifies the item to hold the format information.</p> </li> <li> <p>URL - To integrate this report with your application, use the displayed URL as the target for a button, list item, link, or other navigational component. End users can click a button, for example, to start the printing process.</p> </li> <li> <p>Test Report - Click this to preview your report. If you have chosen to use a generic report layout then the Test Report will not produce an output.</p> </li> <li> <p>Click <span class="bold">Finish</span>.</p> <p>The Report Query is created and saved to Shared Components.</p> </li> </ol> </li> </ol> </div> <!-- class="sect4" --> <a id="BABFCBCA" name="BABFCBCA"></a> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h3><a name="HTMDB25378" id="HTMDB25378"></a>Editing Report <a id="sthref1049" name="sthref1049"></a>Queries</h3> <p>To edit a report query:</p> <ol> <li> <p>Navigate to the Shared Components page. See <a href="bldr_sc_goto.htm#BABEEJAI">"Accessing the Shared Components Page"</a>.</p> </li> <li> <p>Under Reports, click <span class="bold">Report Queries</span>.</p> </li> <li> <p>On the Report Queries page, you can use the Navigation bar at the top of the page to search for a query by name or change the page display. For example, you can change the default display by making a selection from View list. Available options include:</p> <ul> <li> <p><span class="bold">Icons</span> (the default) displays each query as a large icon. To edit a query, click the appropriate icon.</p> </li> <li> <p><span class="bold">Details</span> displays each query as a line in a report. To edit a query, click the name.</p> </li> </ul> </li> <li> <p>Select the appropriate report query. On the Edit Report Query page, edit the information.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </div> <!-- class="sect4" --> <a id="BABBEHAD" name="BABBEHAD"></a> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h3><a name="HTMDB25379" id="HTMDB25379"></a>Copying <a id="sthref1050" name="sthref1050"></a>Report Queries</h3> <p>To copy a report query:</p> <ol> <li> <p>Navigate to the Shared Components page. See <a href="bldr_sc_goto.htm#BABEEJAI">"Accessing the Shared Components Page"</a>.</p> </li> <li> <p>Under Reports, click <span class="bold">Report Queries</span>.</p> </li> <li> <p>On the Report Queries page, click <span class="bold">Copy</span>.</p> </li> <li> <p>On the Copy Report Query, select the query you want to copy, enter a name for the report query, and click <span class="bold">Copy</span>.</p> <p>The copy appears in the query list.</p> </li> </ol> </div> <!-- class="sect4" --></div> <!-- class="sect3" --> <a id="CEGEHDJC" name="CEGEHDJC"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25380" id="HTMDB25380"></a>About <a id="sthref1051" name="sthref1051"></a>Report Layouts</h2> <p>To format either a classic report region or report query, you associate it with a report layout. Using report layouts renders the data in a printer-friendly format. If you do not select a report layout, a default XSL-FO layout is used. The default XSL-FO layout is always used for rendering Interactive Report regions.</p> <p>When creating and using report layouts, you can:</p> <ul> <li> <p>Take advantage of the default layouts for report regions and generic layouts for report queries provided with Oracle Application Express.</p> </li> <li> <p>Utilize the built-in XSL-FO-based layouts for report regions by copying and customizing the code. You can edit a number of attributes for report regions that control page size, fonts, colors, and so on.</p> </li> <li> <p>Create RTF or XSL-FO report layouts to customize the report look and feel. To use RTF report layouts, your Oracle Application Express service administrator must select the Advanced setting for your site. See "Configuring Report Printing" in <a href="AEADM/adm_env.htm"><span class="italic">Oracle Application Express Administration Guide</span></a>.</p> </li> </ul> <a id="sthref1052" name="sthref1052"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="#BABHHBGB">About Report Layout Options</a></p> </li> <li> <p><a href="#BABFCIIA">Creating a Report Layout</a></p> </li> <li> <p><a href="#BABEHJBD">Editing Report Layouts</a></p> </li> <li> <p><a href="#BABJIIBI">Copying Report Layouts</a></p> </li> </ul> <a id="BABHHBGB" name="BABHHBGB"></a> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h3><a name="HTMDB25381" id="HTMDB25381"></a>About Report Layout <a id="sthref1053" name="sthref1053"></a>Options</h3> <p>You can create a report layout based on one of these options:</p> <ul> <li> <p><span class="bold">Generic Columns</span> - A generic report layout works with most query result sets. With this layout, the number of columns is automatically adjusted when generating the printable document.</p> <p>A number of report layout attributes can be defined declaratively for report regions using the built-in XSL-FO default layout. This step allows for creating customizable copies of the built-in default XSL-FO layout, if additional control over the report layout is needed.</p> </li> <li> <p><span class="bold">Named Columns</span> - A named column report layout is a query-specific report layout designed to work with a defined list of columns in the query result set. This type of layout is used for custom-designed layouts when precise control of the positioning of page items and query columns is required.</p> </li> </ul> <p>Note that the availability of the Report Layout options depends on how your site administrator configured the report printing settings at your site. All options described in these steps may not be available to you.</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> "Configuring Report Printing" in <a href="AEADM/adm_env.htm"><span class="italic">Oracle Application Express Administration Guide</span></a>.</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect4" --> <a id="BABFCIIA" name="BABFCIIA"></a> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h3><a name="HTMDB25382" id="HTMDB25382"></a>Creating a <a id="sthref1054" name="sthref1054"></a>Report Layout</h3> <p>To create a report layout:</p> <ol> <li> <p>Navigate to the Shared Components page. See <a href="bldr_sc_goto.htm#BABEEJAI">"Accessing the Shared Components Page"</a>.</p> </li> <li> <p>Under Reports, click <span class="bold">Report Layouts</span>.</p> </li> <li> <p>Click <span class="bold">Create</span>.</p> <p>The Create Report Layout wizard appears.</p> </li> <li> <p>For Report Layout Type, select an option and click <span class="bold">Next</span>:</p> <ul> <li> <p>Generic Columns (XSL-FO) - This layout is pre-populated with a default template, which you can edit to fit your needs.</p> </li> <li> <p>Named Columns (RTF) - This layout is uploaded as an RTF file.</p> </li> <li> <p>Named Columns (XSL-FO) - This layout is uploaded as an XSL-FO file.</p> </li> </ul> </li> <li> <p>For Layout Source, review and edit the appropriate information. The options that appear on this page depend on the layout type you select:</p> <ul> <li> <p>If you selected Generic Columns:</p> </li> </ul> <ol> <li> <p>Report Layout Name - Enter a name to identify the report layout when associating it with a report query or report region.</p> </li> <li> <p>Report Layout - The report layout is the XSL-FO based definition of the page formatting. All attributes defining page size, orientation, fonts, styles, and so on, are defined in this section.</p> <p>To see a list of valid substitution strings and other information, click the item label, <span class="bold">Report Layout</span>. This opens a separate Help window.</p> </li> <li> <p>Report Column Heading - Defines the look of each cell in the report heading row.</p> </li> <li> <p>Report Column - Defines the look of each cell for all report rows.</p> </li> <li> <p>Report Column Width - This width is computed at runtime time or can be derived from the report column definition of a report region.</p> </li> </ol> <ul> <li> <p>If you selected Named Columns:</p> </li> </ul> <ol> <li> <p>Layout Name - Enter a name to identify the report layout when associating it with a report query or report region.</p> </li> <li> <p>8.b) Report Layout File - Upload the file containing the report layout.</p> </li> </ol> </li> </ol> </div> <!-- class="sect4" --> <a id="BABEHJBD" name="BABEHJBD"></a> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h3><a name="HTMDB25383" id="HTMDB25383"></a>Editing Report <a id="sthref1055" name="sthref1055"></a>Layouts</h3> <p>You can edit a generic column report layout directly in Application Express. However, to edit a named column report layout, you must download the current file, edit it, and then upload it again.</p> <p>To edit a report layout:</p> <ol> <li> <p>Navigate to the Shared Components page. See <a href="bldr_sc_goto.htm#BABEEJAI">"Accessing the Shared Components Page"</a>.</p> </li> <li> <p>Under Reports, click <span class="bold">Report Layouts</span>.</p> </li> <li> <p>On the Report Layouts page, select the layout you want to edit.</p> </li> <li> <p>For generic column layouts, edit the layout directly on the Edit Report Layout page and then click <span class="bold">Apply Changes</span>.</p> </li> <li> <p>For named column layouts, click <span class="bold">Download</span> and save the file to your computer.</p> <p>Edit the file and then upload the updated version as a new report layout.</p> </li> </ol> </div> <!-- class="sect4" --> <a id="BABJIIBI" name="BABJIIBI"></a> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h3><a name="HTMDB25384" id="HTMDB25384"></a>Copying Report <a id="sthref1056" name="sthref1056"></a>Layouts</h3> <p>You can copy a report layout to edit and save.</p> <p>To copy a report layout:</p> <ol> <li> <p>Navigate to the Shared Components page. See <a href="bldr_sc_goto.htm#BABEEJAI">"Accessing the Shared Components Page"</a>.</p> </li> <li> <p>Under Reports, click <span class="bold">Report Layouts</span>.</p> </li> <li> <p>On the Report Layouts page, click <span class="bold">Copy</span>.</p> </li> <li> <p>On the Copy Report Layout page, select the layout you want to copy, enter a name for the copy, and click <span class="bold">Copy</span>.</p> <p>The copy appears in the layout list.</p> </li> </ol> </div> <!-- class="sect4" --></div> <!-- class="sect3" --> <a id="CEGHEFFG" name="CEGHEFFG"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25385" id="HTMDB25385"></a>Configuring Classic Report Region<a id="sthref1057" name="sthref1057"></a> Print Attributes</h2> <p>One approach to printing a report region is to configure Print Attributes. Once configured, these attributes only apply only to current region and cannot be used outside the context of the region.</p> <p>If the printing feature is set up for your instance, you can configure a report region to print in various formats.</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="#BABGEGJD">"About Classic Report Printing Methods"</a> and "Configuring Report Printing" in <a href="AEADM/adm_env.htm"><span class="italic">Oracle Application Express Administration Guide</span></a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <p>To configure a classic report region for printing:</p> <ol> <li> <p>In your application, select the page containing the classic report region you want to print.</p> <p>The Page Definition appears.</p> </li> <li> <p>Under Regions, click <span class="bold">Report</span> next to the region you want to print.</p> </li> <li> <p>Click the <span class="bold">Print Attributes</span> tab.</p> </li> <li> <p>Under Printing, specify the appropriate information:</p> <ol> <li> <p>Enable Report Printing - Select <span class="bold">Yes</span>.</p> </li> <li> <p>Link Label - Enter the text for the link that starts the printing process.</p> </li> <li> <p>Response Header - Specify whether the response header generated by Oracle Application Express is based on your <span class="bold">Report Settings</span> or the <span class="bold">Print Server</span>. The response header is the information the server sends back to the Web browser in response to receiving an HTTP request. It contains the date, size and type of file that the server is sending back to the client and also data about the server itself. To specify content disposition (using the attribute View File As) and file name, the response header needs to be based on Report Settings.</p> </li> <li> <p>View File As - Select how the Web browser opens the report query document. Options include:</p> <ul> <li> <p>Attachment - Displays a File Open/Save dialog box when the user clicks the report query download button.</p> </li> <li> <p>Inline - Displays the report query document inside the Browser window.</p> </li> </ul> </li> <li> <p>(Optional) File Name - Enter a name for the downloaded file. If you leave this blank, the region name is used as the file name.</p> </li> <li> <p>Output Format - Select an output option.</p> </li> <li> <p>Item - Determines the output format at runtime. Select the application or page item that holds format value.</p> </li> <li> <p>Report Layout - Select <span class="bold">Default Report Layout</span> to use the built-in generic report layout, or an available report layout you or your administrator created. See item Help for a listing of the supported substitution strings available when building custom XSL-FO report layouts.</p> </li> <li> <p>Print Server Overwrite - Specify an alternate print server. A print server is typically configured centrally for all workspaces in Oracle Application Express Administration Services. See "Configuring Report Printing" in <a href="AEADM/adm_env.htm"><span class="italic">Oracle Application Express Administration Guide</span></a>.</p> <p>Configuring an alternative print server at the report level makes debugging and diagnosis of potential printing problems easier and supports the use of specific custom built end points to perform custom XSLT transformations.</p> </li> <li> <p>Print URL - Report regions can be printed using the standard print link or using a page button. To use a button, remove the Link Label, create a button on your page, and use the URL shown in this attribute as the button target.</p> </li> </ol> </li> <li> <p>In the remaining sections, define page size, paper orientation, page headers and footers, fonts, text color, and background color.</p> </li> <li> <p>Under Report Columns, specify the width for each column.</p> <p>The default is to make each column the same width. The Total Width is a display only field that shows the sum of all column width values. When changing the width for an individual column the Total Width is automatically recalculated. If Column Width Units is set to <span class="bold">Percentage</span>, rather than <span class="bold">Points</span>, then the total column width must be less than or equal to 100.</p> <p>Use the <span class="bold">Reset Column Width</span> button to reset the Column Width Units to <span class="bold">Percentage</span> and change all column widths back to their default value. The <span class="bold">Recalculate</span> button maintains the current ratios between column widths but reduce all column widths such that the Total Width is less than or equal to 100%.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="BABFHBEH" name="BABFHBEH"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25386" id="HTMDB25386"></a>Configuring Interactive Report Region<a id="sthref1058" name="sthref1058"></a> Print Attributes</h2> <p>Unlike classic reports, the Interactive Report Print Attributes can only utilize the default XSL-FO layout and is initiated from the Report Attributes, Download section rather than directly from this screen. Once configured, these attributes only apply only to the current region and cannot be used outside the context of the region.</p> <p>If the printing feature is set up for your instance, you can configure a report region to print in various formats</p> <p>To configure a interactive report region for printing:</p> <ol> <li> <p>In your application, select the page containing the interactive report region you want to print.</p> <p>The Page Definition appears.</p> </li> <li> <p>Under Regions, click <span class="bold">Interactive Report</span> next to the region you want to print.</p> </li> <li> <p>Click the <span class="bold">Print Attributes</span> tab.</p> </li> <li> <p>Under Printing, specify the appropriate information:</p> <ol> <li> <p>Response Header - Specify whether the response header generated by Oracle Application Express is based on your Report Settings or the Print Server. The response header is the information the server sends back to the Web browser in response to receiving an HTTP request. It contains the date, size and type of file that the server is sending back to the client and also data about the server itself. To specify content disposition (using the attribute View File As) and file name, the response header needs to be based on Report Settings.</p> </li> <li> <p>Content Disposition - Select how the Web browser opens the report query document. Options include:</p> <ul> <li> <p>Attachment - Displays a File Open/Save dialog box when the user clicks the report query download button.</p> </li> <li> <p>Inline - Displays the report query document inside the Browser window.</p> </li> </ul> </li> <li> <p>Print Server Overwrite - Specify an alternate print server. A print server is typically configured centrally for all workspaces in Oracle Application Express Administration Services. See "Configuring Report Printing" in <a href="AEADM/adm_env.htm"><span class="italic">Oracle Application Express Administration Guide</span></a>.</p> <p>Configuring an alternative print server at the report level allows for easier debugging and diagnosis of potential printing problems and supports the use of specific custom built end points to perform custom XSLT transformations.</p> </li> </ol> </li> <li> <p>In the remaining sections, define page size, paper orientation, page headers and footers, fonts, text color, and background color.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <!-- 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="bldapp_rpt_int.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_frm.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