Home / Tech Tip / Web Intelligence – Line Number Within Sections

Web Intelligence – Line Number Within Sections

If you save a sectioned report as HTML and choose the “section by section” option, the sections are saved in separate HTML pages numbered from 0 (i.e. 0.htm, 1.htm, etc.).

In wanting to link to these sectioned pages from another sectioned page, you need a way to correspond the link value to the number of the page. Assuming the sort of the values in the linking page is the same as the sort of the sections you wish to link to, this would be the linenumber() function corrected to start at 0.

A problem occurs, however, when the linking report is sectioned, instead of all in one table. When sectioned, you cannot use contexts on the LineNumber() function to force it to continue across sections.

Instead, use the aggregate function RunningSum() which can take a context change.

Then, do a RunningSum() of the count of the objects.

The link, set to read as HTML in the cell formatting, looks like this:

=”<a href=C:\HTMLTest\htmltest\Page2\”+<Link2>+”.htm>”+<Business

Unit>+”</a>”

Where Link2=(RunningSum(Count(<Business Unit>) In (<Division> ,<Business

Unit>)))-1

 

About ckruger

Check Also

Let’s Speak BO Webinar: A Guide to Geographic Charts in Web Intelligence October 31, 2017

Webinar: A Guide to Geographic Charts in Web Intelligence

Join Adam Lange for an informative webinar on geographic visualizations in Web Intelligence 4.2. Attendees …

Leave a Reply

Your email address will not be published. Required fields are marked *