2 Replies Latest reply: Jul 1, 2014 3:43 AM by DanielSagner RSS

    Can't display PDF report with column summary

    DanielSagner

      I have seen many similar posts, but no definitive answer.

      In Apex 4.2.5 (on 11g2) I create Report Query, export xml data, upload it to MS Word and make a simple rtf layout (a table with group above.)

      I upload rtf by creating a Report Layout in Apex, associate it with my Report Query and run (via button). It correctly opens desired pdf.

       

      Now, back in the Word layout I add a summary below repeating group (Field -> Amount -> Calculation -> Sum (Check "on grouping") -> Insert)

      Preview is perfect. However, when I upload this layout back to Apex, PDF does not open: Adobe Reader could not open file... either not supported or damaged... etc.

      So, the Sum function is the apparent culprit (!?) I tried with Count, Min, and Max and it works fine.

      What is the use of a report without summaries?

       

      After reading that null values in the column can cause this, I put nvl(Amount,0) in my view which is the source of data, but it didn't help.

       

      P.S. I am just evaluating Apex and BI Publisher, so I use BIP Trial edition v11.1.1.7.1. May this be the problem? (I'm certainly not going to download 7Gb of BI for making one simple balance sheet for testing purposes).

      Everything is on Win Server 2008 64. Tried with MS Word 2007 and 2010.

       

      Thanks for any suggestions.

      Daniel S.

        • 1. Re: Can't display PDF report with column summary
          DanielSagner

          If I make plain table without grouping, it shows sums. Seems something is wrong with grouping.

          I went through Table Wizard creating three levels, Group by... Then by... Then by... The table is drawn, I save rtf and start preview and it crashes. Error report is too long to paste here; it ends up with:


          Caused by: org.xml.sax.SAXException: Error in expression: './/current-group()'.

          oracle.xdo11g.xpath.XPathException: Error in expression: './/current-group()'.

           

          I didn't touch anything, just went through the Wizard trying to eliminate the factor of my own incompetence, but still no luck.

          • 2. Re: Can't display PDF report with column summary
            DanielSagner

            Dissapointed with my attempts to create layout in MS Word, I tried to do it directly in BI Publisher.

            After a while I was able to create a decent looking report. Everything works, groups, summaries etc. (though I generally expected a somewhat better tool considering it is part of a software with $40k price tag)

            For calling report from Apex I used a 7 years old post from D. Gielis (http://dgielis.blogspot.com/2007/12/call-bi-publisher-report-from-apex.html) and it works fine, passing parameters etc. However, it opens a blank page over Apex application, and then opens Acrobat Reader. After closing Acrobat window, the blank page remains on screen, covering Apex. It looks like a minor nuisance: just click on browser's Go Back button and you are back on your Apex page. However, it turned out that users regularly close the blank page, effectively closing the application alltogether, and they do it unconsciouslly even after being instructed to press Back button.

             

            Has anyone managed to open PDF reader directly, without this blank server page?