Huh. Wow.
So, turns out this is also possible.
Adapting from ReportMill - Table of Contents
- Add a new page (Pages → Add Page Previous)
- Create a new table. Give it a data key of exactly
TOC.<dataKey>.<dataKey>
- Add cells to the details row. Use the existing builtin
@Row@
for the row within the table, the unique-to-table-of-contents@page@
to refer to the page that a particular key exists on, and just use@<columnName>@
to refer to values from the actual grouping key. - Preview the report - the reporting engine should automatically recognize the
TOC
key and insert a table of contents.
To test, I’m using a simple SQL query (SELECT * FROM SQLTH_TE
) with a table set up so that I end up with a few rows per page, but always multiple pages.
My table of contents table looks like this:
And the rendered output looks like this: