Forum Discussion

ABott73's avatar
ABott73
New Contributor II
3 years ago

Page Numbering Format for Books

Hi Just wondering if it's possible to format the page numbering when running books to ensure the output is based upon the page number and the total no of pages in the book.  For example if there were...
Reports
JackLacava's avatar
JackLacava
Community Manager
3 years ago

The posted formula works fine for me in OneStream 7.2.2: adding multiple Report items, {0} will contain the current page relative to the whole book, and {1} the total number of pages in the book. E.g. if ReportA has 1 page and ReportB has 2 pages, the footers will be "1 of 3", "2 of 3", and "3 of 3".

  • ABott73's avatar
    ABott73
    New Contributor II
    3 years ago

    Thanks for the quick response.  We are currently on 7.1.1 and with multiple reports in the book the page numbering isn't working correctly.  Do you know if there was a fix to it between versions?  If not then I'll see if there is something else causing the issue.

    Thanks again

    • JackLacava's avatar
      JackLacava
      Community Manager
      3 years ago

      One thing to note is that i didn't bother with the first SetPageNumberDisplayInfo "dummy" call to clear it, i just went straight for the second one.

      On fixes, I don't see anything in Release Notes but they don't list every little bug fixed. Maybe consider upgrading a dev environment to 7.2.2 and see how it goes.

  • Amarappan's avatar
    Amarappan
    New Contributor
    3 years ago

    Hi Jack,

    we are using OS 7.2.2 version, and getting the output as "1 of 1" ; "2 of 2" as page number in report footer for books.

    Please let me know, if I am missing something. Thanks in advance.

     

    • JackLacava's avatar
      JackLacava
      Community Manager
      3 years ago

      This is what I used.

       

      Dim uiItem As CVExtenderReportUIItem = args.Report.CurrentUIItem
If uiItem.UIItemType = XFReportUIItemType.PageFooterPageNumber Then
	uiItem.SetPageNumberDisplayInfo(True, "page {0} of {1}")
End If

       

      I have a book with three report elements: 2 pages, 1 page, 2 pages. The output I get is not perfect all the time, so there might be a few gremlins still; today it looks like this:

       

      page 1 of 2
page 2 of 2
page 3 of 5
page 4 of 5
page 5 of 5

       

      So I would say {0} is reliable, whereas {1} might not always be.

      If that code doesn't work like that for you, consider opening a Support case.

      • ABott73's avatar
        ABott73
        New Contributor II
        3 years ago

        Thanks Jack that's exactly the issue and is inconsistent but I'll raise it as a support case anyway.  Thanks again