Skip to main content

Printing Page Numbers in RTF Template [Oracle BI Publisher]

Here I am giving an example to print the page numbers dynamically in the RTF (Rich Text Format) template.

Step 1: Go to page footer and copy and paste the below script.

Page | <?fo:page-number?> of <?fo:page-number-citation:xdofo:lastpage-joinseq?>


<fo:page-number>
: 
This is the object, which is used to represent the current page-number.

<?fo:page-number-citation:xdofo:lastpage-joinseq?>This is the syntax, which is used to represent the total number of pages.

Step 2: Load the XML and preview the result.

Output:


That's it.

References:

Comments

  1. The idea is to understand the Mobile Web APPquality and how to improve it using the latest tools and features. The Mobile Web APP quality is important for a Web APP to become more popular and easier to use. What is Mobile Web APP quality? Mobile Web APP quality is a quality standard that indicates the quality of a Mobile Web APP.

    ReplyDelete
  2. dynamic pricing and billing
    Personalize products, offers, pricing and loyalty programs; prevent revenue leakage and ensure regulatory compliance with a billing solution.

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle Application Express Views (APEX)

Application Express Views Search SELECT * FROM apex_dictionary WHERE column_id = 0; View Comment Parent View APEX_APPLICATIONS Applications defined in the current workspace or database user. APEX_WORKSPACES APEX_APPLICATION_ALL_AUTH All authorization schemes for all components by Application APEX_APPLICATIONS

Save Selected Interactive Grid Records into a Collection - Oracle APEX

Here I am giving an example to save selected interactive grid records into a oracle apex collection. Step 1: Create a new blank page. Note: Mine was page 20. You will need to update reference to " P20 " with your page number if it's different. Step 2: Create a new interactive grid report region to the page using below query. Set Static Id "EmpDetails" to the region. SELECT  *     FROM   ( SELECT  emp . empno ,                emp . ename ,                emp . JOB ,                dept . dname department ,                dept . loc  LOCATION ,                mgr . ename  manager ,                emp . hiredate ,                 nvl ( emp . sal , 0 )  salary ,                 nvl ( emp . comm , 0 )  commission            FROM  eba_demo_chart_emp emp ,                eba_demo_chart_dept dept ,                eba_demo_chart_emp mgr           WHERE  emp . deptno = dept . deptno             AND  emp . mgr      = mgr . empno  ( + )           ORDER   BY  emp . ename