5 Replies Latest reply on May 6, 2014 7:29 AM by Arif Khadas

    Print option of the Report generates corrupted PDF file.

    Arif Khadas

      Dear All,

       

      I have enabled the Print option of a Report Region.

      Enable Report Printing Yes

      Response Header Report Settings

      View File as Attachment

      Output Format PDF

       

      When I run the Page and Click on Print, PDF File is generated and saved,

      but on opening it Failed to load PDF document error occurs.

       

      Application Express 4.2.2.00.11

       

      Please help.

       

      Best Regards

       

      Arif Khadas

        • 1. Re: Print option of the Report generates corrupted PDF file.
          TexasApexDeveloper

          Kinda hard to help here since you are NOT telling us everything.. Lets start with.. DO you have a print server setup with APEX?  Are you using the APEX Listener or the HTTP server? If you open the PDF from a text editor, what does the file contain?

           

          Thank you,

           

          Tony Miller
          LuvMuffin Software
          Ruckersville, VA

          • 2. Re: Print option of the Report generates corrupted PDF file.
            Arif Khadas

            Thanks Tony Miller for your reply.

             

            For Print Server Setup following has been done from Internal Workspace :

            Manage Instance > Instance Settings > Report Printing > Oracle APEX Listener

             

            The PDF file when opened in text editor has the following

             

            <?xml version="1.0" encoding="UTF-8"?>

            <apexListnerFOP>

            <DOCUMENT>

               <DATE>30-APR-14</DATE>

               <USER_NAME>ADMIN</USER_NAME>

               <APP_ID>1002</APP_ID>

               <APP_NAME>Bridges Real Estate</APP_NAME>

               <PAGE_ID>2</PAGE_ID>

               <TITLE>Property</TITLE>

              <P2_STOP_START></P2_STOP_START>

              <P2_BLD_STATUS></P2_BLD_STATUS>

              <P2_BLD_TYPE></P2_BLD_TYPE>

               <REGION ID="4712632222371320">

                  <ROWSET>

                     <ROW>

                        <BLD_PRT_NUM>????? ??????</BLD_PRT_NUM>

                        <BLD_STATUS_CODE>Running</BLD_STATUS_CODE>

                        <BLD_TYPE>Commercial Bldg</BLD_TYPE>

                        <BLD_NUM>B101</BLD_NUM>

                        <BLD_DESC>???? B101</BLD_DESC>

                        <BLD_NO></BLD_NO>

                        <BLD_REF></BLD_REF>

                        <BLD_CIVIL_ID></BLD_CIVIL_ID>

                        <BLD_REG></BLD_REG>

                        <BLD_USAGE>-</BLD_USAGE>

                        <BLD_APRV_FLG>Yes</BLD_APRV_FLG>

                        <BLD_START_DATE>20-NOV-07</BLD_START_DATE>

                        <BLD_END_DATE></BLD_END_DATE>

                        <BLD_PROD_YEAR></BLD_PROD_YEAR>

                        <BLD_COST></BLD_COST>

                     </ROW>

                     <ROW>

                        <BLD_PRT_NUM>Abu Halifa Portfolio</BLD_PRT_NUM>

                        <BLD_STATUS_CODE>Under Preparation</BLD_STATUS_CODE>

                        <BLD_TYPE>Commercial Bldg</BLD_TYPE>

                        <BLD_NUM>223</BLD_NUM>

                        <BLD_DESC>Stopped Property</BLD_DESC>

                        <BLD_NO></BLD_NO>

                        <BLD_REF></BLD_REF>

                        <BLD_CIVIL_ID></BLD_CIVIL_ID>

                        <BLD_REG></BLD_REG>

                        <BLD_USAGE>-</BLD_USAGE>

                        <BLD_APRV_FLG>-</BLD_APRV_FLG>

                        <BLD_START_DATE>23-SEP-06</BLD_START_DATE>

                        <BLD_END_DATE></BLD_END_DATE>

                        <BLD_PROD_YEAR></BLD_PROD_YEAR>

                        <BLD_COST></BLD_COST>

                     </ROW>

                     <ROW>

                        <BLD_PRT_NUM></BLD_PRT_NUM>

                        <BLD_STATUS_CODE>Freezed</BLD_STATUS_CODE>

                        <BLD_TYPE>Commercial Bldg</BLD_TYPE>

                        <BLD_NUM>500</BLD_NUM>

                        <BLD_DESC>Abu Halifa Property</BLD_DESC>

                        <BLD_NO>500</BLD_NO>

                        <BLD_REF></BLD_REF>

                        <BLD_CIVIL_ID></BLD_CIVIL_ID>

                        <BLD_REG></BLD_REG>

                        <BLD_USAGE>-</BLD_USAGE>

                        <BLD_APRV_FLG>Yes</BLD_APRV_FLG>

                        <BLD_START_DATE>23-SEP-06</BLD_START_DATE>

                        <BLD_END_DATE></BLD_END_DATE>

                        <BLD_PROD_YEAR>1980</BLD_PROD_YEAR>

                        <BLD_COST>1,000,000.000</BLD_COST>

                     </ROW>

                     <ROW>

                        <BLD_PRT_NUM>Fintas Portfolio</BLD_PRT_NUM>

                        <BLD_STATUS_CODE>Running</BLD_STATUS_CODE>

                        <BLD_TYPE>Commercial Bldg</BLD_TYPE>

                        <BLD_NUM>456</BLD_NUM>

                        <BLD_DESC>Prospect property</BLD_DESC>

                        <BLD_NO></BLD_NO>

                        <BLD_REF></BLD_REF>

                        <BLD_CIVIL_ID></BLD_CIVIL_ID>

                        <BLD_REG></BLD_REG>

                        <BLD_USAGE>-</BLD_USAGE>

                        <BLD_APRV_FLG>Yes</BLD_APRV_FLG>

                        <BLD_START_DATE>28-AUG-06</BLD_START_DATE>

                        <BLD_END_DATE></BLD_END_DATE>

                        <BLD_PROD_YEAR></BLD_PROD_YEAR>

                        <BLD_COST></BLD_COST>

                     </ROW>

                     <ROW>

                        <BLD_PRT_NUM></BLD_PRT_NUM>

                        <BLD_STATUS_CODE>Running</BLD_STATUS_CODE>

                        <BLD_TYPE>Commercial Bldg</BLD_TYPE>

                        <BLD_NUM>100</BLD_NUM>

                        <BLD_DESC>Waha Complex</BLD_DESC>

                        <BLD_NO>443324</BLD_NO>

                        <BLD_REF>54455</BLD_REF>

                        <BLD_CIVIL_ID>32234</BLD_CIVIL_ID>

                        <BLD_REG>54555</BLD_REG>

                        <BLD_USAGE>Residential</BLD_USAGE>

                        <BLD_APRV_FLG>Yes</BLD_APRV_FLG>

                        <BLD_START_DATE>20-JUL-06</BLD_START_DATE>

                        <BLD_END_DATE></BLD_END_DATE>

                        <BLD_PROD_YEAR>2006</BLD_PROD_YEAR>

                        <BLD_COST>345,435.000</BLD_COST>

                     </ROW>

                     <ROW>

                        <BLD_PRT_NUM></BLD_PRT_NUM>

                        <BLD_STATUS_CODE>Running</BLD_STATUS_CODE>

                        <BLD_TYPE>Commercial Bldg</BLD_TYPE>

                        <BLD_NUM>200</BLD_NUM>

                        <BLD_DESC>Property 200</BLD_DESC>

                        <BLD_NO></BLD_NO>

                        <BLD_REF></BLD_REF>

                        <BLD_CIVIL_ID></BLD_CIVIL_ID>

                        <BLD_REG></BLD_REG>

                        <BLD_USAGE>-</BLD_USAGE>

                        <BLD_APRV_FLG>Yes</BLD_APRV_FLG>

                        <BLD_START_DATE>21-JUL-06</BLD_START_DATE>

                        <BLD_END_DATE></BLD_END_DATE>

                        <BLD_PROD_YEAR></BLD_PROD_YEAR>

                        <BLD_COST></BLD_COST>

                     </ROW>

                     <ROW>

                        <BLD_PRT_NUM></BLD_PRT_NUM>

                        <BLD_STATUS_CODE>Under Preparation</BLD_STATUS_CODE>

                        <BLD_TYPE>Commercial Bldg</BLD_TYPE>

                        <BLD_NUM>77777</BLD_NUM>

                        <BLD_DESC>Sahab Center</BLD_DESC>

                        <BLD_NO></BLD_NO>

                        <BLD_REF></BLD_REF>

                        <BLD_CIVIL_ID></BLD_CIVIL_ID>

                        <BLD_REG></BLD_REG>

                        <BLD_USAGE>-</BLD_USAGE>

                        <BLD_APRV_FLG>-</BLD_APRV_FLG>

                        <BLD_START_DATE>01-JAN-00</BLD_START_DATE>

                        <BLD_END_DATE></BLD_END_DATE>

                        <BLD_PROD_YEAR></BLD_PROD_YEAR>

                        <BLD_COST></BLD_COST>

                     </ROW>

                     <ROW>

                        <BLD_PRT_NUM></BLD_PRT_NUM>

                        <BLD_STATUS_CODE>Under Preparation</BLD_STATUS_CODE>

                        <BLD_TYPE>Commercial Bldg</BLD_TYPE>

                        <BLD_NUM>4433</BLD_NUM>

                        <BLD_DESC>Merjan Center</BLD_DESC>

                        <BLD_NO></BLD_NO>

                        <BLD_REF></BLD_REF>

                        <BLD_CIVIL_ID></BLD_CIVIL_ID>

                        <BLD_REG></BLD_REG>

                        <BLD_USAGE>-</BLD_USAGE>

                        <BLD_APRV_FLG>No</BLD_APRV_FLG>

                        <BLD_START_DATE>04-AUG-06</BLD_START_DATE>

                        <BLD_END_DATE></BLD_END_DATE>

                        <BLD_PROD_YEAR></BLD_PROD_YEAR>

                        <BLD_COST></BLD_COST>

                     </ROW>

                     <ROW>

                        <BLD_PRT_NUM></BLD_PRT_NUM>

                        <BLD_STATUS_CODE>Under Preparation</BLD_STATUS_CODE>

                        <BLD_TYPE>Commercial Bldg</BLD_TYPE>

                        <BLD_NUM>666</BLD_NUM>

                        <BLD_DESC>prospect bld 666</BLD_DESC>

                        <BLD_NO></BLD_NO>

                        <BLD_REF></BLD_REF>

                        <BLD_CIVIL_ID></BLD_CIVIL_ID>

                        <BLD_REG></BLD_REG>

                        <BLD_USAGE>Residential</BLD_USAGE>

                        <BLD_APRV_FLG>-</BLD_APRV_FLG>

                        <BLD_START_DATE>15-DEC-07</BLD_START_DATE>

                        <BLD_END_DATE></BLD_END_DATE>

                        <BLD_PROD_YEAR></BLD_PROD_YEAR>

                        <BLD_COST></BLD_COST>

                     </ROW>

                     <ROW>

                        <BLD_PRT_NUM></BLD_PRT_NUM>

                        <BLD_STATUS_CODE>Prospect Property</BLD_STATUS_CODE>

                        <BLD_TYPE>Commercial Bldg</BLD_TYPE>

                        <BLD_NUM>234</BLD_NUM>

                        <BLD_DESC>234</BLD_DESC>

                        <BLD_NO></BLD_NO>

                        <BLD_REF></BLD_REF>

                        <BLD_CIVIL_ID></BLD_CIVIL_ID>

                        <BLD_REG></BLD_REG>

                        <BLD_USAGE>-</BLD_USAGE>

                        <BLD_APRV_FLG>-</BLD_APRV_FLG>

                        <BLD_START_DATE>04-SEP-06</BLD_START_DATE>

                        <BLD_END_DATE></BLD_END_DATE>

                        <BLD_PROD_YEAR></BLD_PROD_YEAR>

                        <BLD_COST></BLD_COST>

                     </ROW>

                     <ROW>

                        <BLD_PRT_NUM></BLD_PRT_NUM>

                        <BLD_STATUS_CODE>Sales Inventory</BLD_STATUS_CODE>

                        <BLD_TYPE>Commercial Bldg</BLD_TYPE>

                        <BLD_NUM>22222</BLD_NUM>

                        <BLD_DESC>test</BLD_DESC>

                        <BLD_NO></BLD_NO>

                        <BLD_REF></BLD_REF>

                        <BLD_CIVIL_ID></BLD_CIVIL_ID>

                        <BLD_REG></BLD_REG>

                        <BLD_USAGE>-</BLD_USAGE>

                        <BLD_APRV_FLG>Yes</BLD_APRV_FLG>

                        <BLD_START_DATE>15-SEP-09</BLD_START_DATE>

                        <BLD_END_DATE></BLD_END_DATE>

                        <BLD_PROD_YEAR></BLD_PROD_YEAR>

                        <BLD_COST></BLD_COST>

                     </ROW>

                  </ROWSET>

               </REGION>

            </DOCUMENT>

            <xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:xlink="http://www.w3.org/1999/xlink">

               <xsl:variable name="_XDOFOPOS" select="''"/>

               <xsl:variable name="_XDOFOPOS2" select="number(1)"/>

               <xsl:variable name="_XDOFOTOTAL" select="number(1)"/>

               <xsl:variable name="_XDOFOOSTOTAL" select="number(0)"/>

               <xsl:attribute-set name="padding">

                  <xsl:attribute name="padding-bottom">0.25pt</xsl:attribute>

                  <xsl:attribute name="padding-top">0.25pt</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="text">

                  <xsl:attribute name="text-align">start</xsl:attribute>

                  <xsl:attribute name="orphans">2</xsl:attribute>

                  <xsl:attribute name="start-indent">0.0pt</xsl:attribute>

                  <xsl:attribute name="linefeed-treatment">preserve</xsl:attribute>

                  <xsl:attribute name="padding-top">0.0pt</xsl:attribute>

                  <xsl:attribute name="end-indent">0.0pt</xsl:attribute>

                  <xsl:attribute name="padding-bottom">0.0pt</xsl:attribute>

                  <xsl:attribute name="height">0.0pt</xsl:attribute>

                  <xsl:attribute name="widows">2</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="align-left">

                  <xsl:attribute name="text-align">left</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="align-center">

                  <xsl:attribute name="text-align">center</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="align-right">

                  <xsl:attribute name="text-align">right</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="footer">

                  <xsl:attribute name="text-align">right</xsl:attribute>

                  <xsl:attribute name="start-indent">5.4pt</xsl:attribute>

                  <xsl:attribute name="end-indent">5.4pt</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="text_2">

                  <xsl:attribute name="start-indent">5.4pt</xsl:attribute>

                  <xsl:attribute name="end-indent">23.4pt</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="text_20">

                  <xsl:attribute name="height">13.872pt</xsl:attribute>

                  <xsl:attribute name="end-indent">5.4pt</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="text_0">

                  <xsl:attribute name="end-indent">5.4pt</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="page-header">

                  <xsl:attribute name="color">#000000</xsl:attribute>

                  <xsl:attribute name="font-family">Helvetica</xsl:attribute>

                  <xsl:attribute name="white-space-collapse">false</xsl:attribute>

                  <xsl:attribute name="font-size">12pt</xsl:attribute>

                  <xsl:attribute name="font-weight">normal</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="page-footer">

                  <xsl:attribute name="color">#000000</xsl:attribute>

                  <xsl:attribute name="font-family">Helvetica</xsl:attribute>

                  <xsl:attribute name="white-space-collapse">false</xsl:attribute>

                  <xsl:attribute name="font-size">12pt</xsl:attribute>

                  <xsl:attribute name="font-weight">normal</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="body-font">

                  <xsl:attribute name="height">12.0pt</xsl:attribute>

                  <xsl:attribute name="font-family">Helvetica</xsl:attribute>

                  <xsl:attribute name="white-space-collapse">false</xsl:attribute>

                  <xsl:attribute name="font-size">10pt</xsl:attribute>

                  <xsl:attribute name="font-weight">normal</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="page-number">

                  <xsl:attribute name="height">13.872pt</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="header-font">

                  <xsl:attribute name="height">10pt</xsl:attribute>

                  <xsl:attribute name="font-family">Helvetica</xsl:attribute>

                  <xsl:attribute name="white-space-collapse">false</xsl:attribute>

                  <xsl:attribute name="font-size">10pt</xsl:attribute>

                  <xsl:attribute name="font-weight">normal</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="border">

                  <xsl:attribute name="border-top">       .50pt solid #000000</xsl:attribute>

                  <xsl:attribute name="border-bottom">       .50pt solid #000000</xsl:attribute>

                  <xsl:attribute name="border-start-width">       .50pt</xsl:attribute>

                  <xsl:attribute name="border-start-color">#000000</xsl:attribute>

                  <xsl:attribute name="border-start-style">solid</xsl:attribute>

                  <xsl:attribute name="border-end-width">       .50pt</xsl:attribute>

                  <xsl:attribute name="border-end-color">#000000</xsl:attribute>

                  <xsl:attribute name="border-end-style">solid</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="cell">

                  <xsl:attribute name="background-color">#efefef</xsl:attribute>

                  <xsl:attribute name="color">#000000</xsl:attribute>

                  <xsl:attribute name="padding-start">5.15pt</xsl:attribute>

                  <xsl:attribute name="vertical-align">top</xsl:attribute>

                  <xsl:attribute name="padding-top">0.0pt</xsl:attribute>

                  <xsl:attribute name="padding-end">5.15pt</xsl:attribute>

                  <xsl:attribute name="number-columns-spanned">1</xsl:attribute>

                  <xsl:attribute name="height">0.0pt</xsl:attribute>

                  <xsl:attribute name="padding-bottom">0.0pt</xsl:attribute>

               </xsl:attribute-set>

               <xsl:attribute-set name="header-color">

                  <xsl:attribute name="background-color">#9bafde</xsl:attribute>

                  <xsl:attribute name="color">#ffffff</xsl:attribute>

               </xsl:attribute-set>

               <xsl:template match="/">

                  <fo:root>

                     <fo:layout-master-set>

                        <fo:simple-page-master master-name="master0" margin-left="66.6pt" margin-right="66.6pt" page-height="    612.00pt" page-width="    792.00pt" margin-top="36.0pt" margin-bottom="36.0pt">

                           <fo:region-body region-name="region-body" margin-top="54.0pt" margin-bottom="54.0pt"/>

                           <fo:region-before region-name="region-header" extent="54.0pt"/>

                           <fo:region-after region-name="region-footer" extent="54.0pt" display-align="after"/>

                        </fo:simple-page-master>

                     </fo:layout-master-set>

                     <fo:page-sequence master-reference="master0">

                        <xsl:variable name="_PW" select="number(    612.00)"/>

                        <xsl:variable name="_PH" select="number(    792.00)"/>

                        <xsl:variable name="_ML" select="number(72.0)"/>

                        <xsl:variable name="_MR" select="number(72.0)"/>

                        <xsl:variable name="_MT" select="number(90.0)"/>

                        <xsl:variable name="_MB" select="number(90.0)"/>

                        <xsl:variable name="_HY" select="number(36.0)"/>

                        <xsl:variable name="_FY" select="number(36.0)"/>

                        <xsl:variable name="_SECTION_NAME" select="string('master0')"/>

                        <fo:static-content flow-name="region-header">

                           <fo:block xsl:use-attribute-sets="text text_2 text_0 align-center">

                              <fo:inline xsl:use-attribute-sets="page-header"></fo:inline>

                           </fo:block>

                        </fo:static-content>

                        <fo:static-content flow-name="region-footer">

                           <fo:block xsl:use-attribute-sets="text footer">

                              <fo:inline xsl:use-attribute-sets="body-font page-number">

                                 <fo:page-number/>

                              </fo:inline>

                           </fo:block>

                           <fo:block xsl:use-attribute-sets="text text_2 align-center">

                              <fo:inline xsl:use-attribute-sets="page-footer"></fo:inline>

                           </fo:block>

                        </fo:static-content>

                        <fo:flow flow-name="region-body">

                           <fo:block xsl:use-attribute-sets="padding">

                              <fo:table start-indent="0.0pt">

                                 <xsl:variable name="_XDOFOPOS2" select="number(1)"/>

                                 <xsl:variable name="_XDOFOTOTAL" select="number(1)"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-column column-width="40pt"/>

                                 <fo:table-header>

                                    <fo:table-row>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">Portfolio</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">Status</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">Type</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">#</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">Description</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">No</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">Reference</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">Civil Id</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">Reg No.</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">Activity</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">Approved</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">Start</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">End</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">Year</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                       <fo:table-cell xsl:use-attribute-sets="cell header-color border">

                                           <fo:block xsl:use-attribute-sets="text align-center">

                                               <fo:inline xsl:use-attribute-sets="header-font">Cost</fo:inline>

                                           </fo:block>

                                       </fo:table-cell>

                                    </fo:table-row>

                                 </fo:table-header>

                                 <fo:table-body>

                                    <xsl:for-each select=".//ROW">

                                       <fo:table-row>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-left">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_PRT_NUM"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-left">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_STATUS_CODE"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-left">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_TYPE"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-left">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_NUM"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-left">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_DESC"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-left">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_NO"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-left">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_REF"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-left">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_CIVIL_ID"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-left">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_REG"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-left">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_USAGE"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-left">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_APRV_FLG"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-left">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_START_DATE"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-left">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_END_DATE"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-left">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_PROD_YEAR"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                          <fo:table-cell xsl:use-attribute-sets="cell border">

                                              <fo:block xsl:use-attribute-sets="text align-right">

                                                  <fo:inline xsl:use-attribute-sets="body-font">

                                                      <xsl:value-of select=".//BLD_COST"/>

                                                  </fo:inline>

                                              </fo:block>

                                          </fo:table-cell>

                                       </fo:table-row>

                                    </xsl:for-each>

                                 </fo:table-body>

                              </fo:table>

                           </fo:block>

                           <fo:block xsl:use-attribute-sets="text text_2 text_20">

                              <fo:inline id="{concat('page-total-', $_SECTION_NAME, $_XDOFOPOS)}"/>

                              <fo:inline id="{concat('page-total', $_XDOFOPOS)}"/>

                           </fo:block>

                        </fo:flow>

                     </fo:page-sequence>

                  </fo:root>

               </xsl:template>

            </xsl:stylesheet>

            </apexListnerFOP>

            • 3. Re: Print option of the Report generates corrupted PDF file.
              TexasApexDeveloper

              That does NOT look like a valid PDF file, it looks more like an xml-stylesheet for formatting your output to a pdf..

               

              Thank you,

               

              Tony Miller
              LuvMuffin Software
              Ruckersville, VA

              • 4. Re: Print option of the Report generates corrupted PDF file.
                Arif Khadas

                Once again Thanks Tony Miller for your reply.

                 

                That is the file generated as pdf from the PRINT link of report.

                 

                So why is the file not generated properly.

                • 5. Re: Print option of the Report generates corrupted PDF file.
                  Arif Khadas

                  Clarifying some points again so that I can get a better response :

                  Trying to use PRINT in APEX using APEX Listener for PDF printing.
                  Followed the link http://marcsewtz.blogspot.com/2013/04/pdf-printing-with-oracle-application.html
                  to setup the configuration in the APEX Instance Administration and setup Report Print properties.

                  PDF is downloaded but when I open it the PDF does not open as it not being a supported file type or damaged.

                  My Oracle Database version Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
                  and Oracle Application Express 4.2.2.00.11

                  The Prerequisites as mentioned inhttp://www.oracle.com/technetwork/developer-tools/apex/learnmore/custom-pdf-reports-1953918.pdf
                  requires
                  1. Oracle Database 11g, so will that not work in 10g?
                  Install and configure Oracle Application Express Listener 2.0.2 or above as a web listener, how can the Version of APEX Listener be known or is it configured or not?

                  If any one has any experience using APEX Listener for PDF printing, please help.

                  Thanks & Regards