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.
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.
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:
The I created one input control liked to each variable:
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:
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:
So you can see that the totals are not changing whenever we scroll down or up in the table.
You can see in the published video how we can play with the table and the input controls: https://youtu.be/mf7iYovuf5w.
You can download the Web Intelligence report attached to that publication.
Didier MAZOUE
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |