In a previous publication I described how we can display a large number of values on a chart and zoom in the chart using input controls: Charts windowing.

Concerning tables this is not really an issue because a table can be displayed on multiple charts.

If we have to export to PDF, Excel or print the report this is of course mandatory.

But in some cases it could be interesting to display the table on a single page and scroll inside the table without changing pages.

Tables scrolling

So the idea is to change the content of a table without changing page. Moreover, we can also set the number of visible rows in the table as the below screenshot.

Table scrolling - 1.png

In the above example, there are 2 tables and I created a break on Product categories in the first table and a break on Country in the second table.

To scroll in the table, I created 2 numeric variables:

  • Number of visible rows: =0
  • Vertical scrolling: =0

The I created one input control liked to each variable:

  • Number of visible rows:
    • Minimum value: 1
    • Maximum value: 40
    • Maximum value: 1
    • Default value: 20
  • Vertical scrolling:
    • Minimum value: 1
    • Maximum value: 700
    • Maximum value: 1
    • Default value: 1

So the table can display from 1 to 40 rows.

And in, my example, the table can contain from 1 to 700 rows

Now to use the 2 input controls with the tables I created a variable named “MaxRows” with the following formula:

=If RowIndex() >= [Vertical scrolling] And RowIndex() <= [Vertical scrolling] + [Number of visible rows] Then “OK”

And I created the following filter applied on the report: MaxRows Equal To “OK”

So the table only displays the rows between the value of [Vertical scrolling] and [Vertical scrolling] + [Number of visible rows]

See below screenshot:

Table scrolling - 2.png

As the total for the break is changing when the scrolling variables change I added 2 other subtotals to always have the correct total for Order Quantity and Sales Amount:

  • =Sum(NoFilter( [Order Quantity]))
  • =Sum(NoFilter( [Sales Amount]))

So you can see that the totals are not changing whenever we scroll down or up in the table.

Table scrolling - 4.png

Table scrolling - 3.png

You can see in the published video how we can play with the table and the input controls:

You can download the Web Intelligence report attached to that publication.


To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply