Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Page number of Page Count Peoplecode for BIP Report Merger — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Page number of Page Count Peoplecode for BIP Report Merger

Received Response
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment


How to get the Total page Count when merging 2 reports?


Hi All,

I have 2 BI Publisher reports that are getting merged in an App Engine into 1 report pdf. I can use the following to get the page number:

      /*** Page Number ***/
      Local PSXP_ENGINE:PageNumber &oPageNumber = create PSXP_ENGINE:PageNumber();
      &oPageNumber.FontName = "Arial";
      &oPageNumber.FontSize = 7;
      &oPageNumber.PositionX = 400;
      &oPageNumber.PositionY = 15;
      &oMerger.PageNumber = &oPageNumber;

However, I need to get the total number of pages between the two reports that are merged in the app engine (Report 1 = 10pgs, Report 2 = 1 pg, Total = 11pgs)

Does anyone know of a function or method I can use to do this? An Array perhaps??

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!