Adding page number in webi report based on section

[Former Member]

I have a condition where a section can grow upto 2 or 3 pages and I want to show page number according to that section.For each new section page number should start from 1 and increment until the section ends.

I tried using In section operator but that doesn't seems to be helpful.

[Former Member · Accepted solution]

Hi Vivek,

Could you please test the following solutions to resolve the issue.

Solution1:

To display the page numbers from the first according to the section details i.e based on the number of sections in a report.

example: If a report has3 sctions and first section comes in 3 pages,2nd section comes in 4 pages and 3rd section in 2 pages, then total number of pages is9. Then the display of page numbers should be [page number of section in(1,2or3)/total number of pages in all the sections]

Insert a cell within a page and insert the formula

=Concatenation("Page"" " ,PageInSection(1)" ")

*****

If the above doesnu2019t works then please try the following solution.

Solution2:

--Create a report with section.

--Format the Section to "Start on a new page"

--Apply Page Layout to the report

--Insert a Cell and apply function PageInSection()

I hope this will help you.

Regards,

Deepti Bajpai

[Former Member · Accepted solution]

Hi Deepti,

What version of Web Intelligence are you on. PageInSection is not available at 3.0 - is it available in 3.1?

Regards

Alan

[Former Member · Accepted solution]

Hi Alan

No. It's still a DeskI only function.

Regards

Charles

[Former Member · Accepted solution]

Thanks everybody for responding.

Charles - Is there any way I can implement it in webi reports?

[Former Member · Accepted solution]

Hi Vivek,

I tried to implement this manually but with no success. I tried looking at running count of the page number reseting against the section dimension.

Regards

Alan

[Boyan_P · Accepted solution]

There isn't such a function PageInSection() yet.
An Enhancement Request has been created for this under  Request # ADAPT00744102 but it is not yet reproduced.