Turn Report into PPR Report

Written by Paulo Vale on Monday, December 10, 2007

You can turn your reports into PPR (Partial Page Request) reports in an easy way, making little changes to your templates. Follow me...

1- Create or edit a report template.

2- Before rows section: add the following html before the open table tag.

<div id="report#REGION_ID#"><htmldb:#REGION_ID#>

3- After rows section: add the following html after the close table tag.
<script language=JavaScript type=text/javascript>
<!--
init_htmlPPRReport('#REGION_ID#');

//-->
</script>
</htmldb:#REGION_ID#>
</div>

4- Pagination Subtemplate: modify Next Page Template, Previous Page Template, Next Set Template and Previous Set Template sections, changing this code...
<a href="#LINK#"

... by this one.
<a href="javascript:html_PPR_Report_Page(this,'#REGION_ID#','#LINK#')"

And it's done. You get a PPR (Partial Page Request) template. This trick can also be used to obtain a custom row based PPR report.

Related Posts by Categories



Widget by Hoctro | Jack Book
  1. 3 comments: Responses to “ Turn Report into PPR Report ”

  2. By Unknown on November 18, 2008 at 8:31 PM

    Great tip. Quick follow-up. How do you customize the actual pagination links? For instance, I would like my links to resemble the following:

    FIRST PREV 1 2 3 4 5 6 7 8 9 10 NEXT LAST


    I want a max of ten numbers in the sequence, so if I click on NEXT, I would like the pagination links to look like:

    FIRST PREV 2 3 4 5 6 7 8 9 10 11 NEXT LAST


    I've been looking through docs, blogs, forums, but can't seem to find out how.

  3. By Paulo Vale on November 18, 2008 at 8:48 PM

    Hi tanebhan,

    Glad you liked it :)

    Are you using APEX 3.1? If yes, you can choose "Search Engine" pagination for your report and then enable PPR like I've said on this post: http://apex-notes.blogspot.com/2008/04/partial-page-request-reports.html

  4. By Balaji Subramaniam on May 17, 2011 at 11:07 AM

    Hi Paulo,

    I have followed the steps to implement Partial Page Rendering. I am getting the following error message.

    Bad Request
    Your browser sent a request that this server could not understand.
    mod_plsql: /pls/apexdev/f HTTP-400 Bad name in the request: not a legal PLSQL identifer


    Please help me to resolve this issue.

    Regards
    Balaji S