# Ignition Report creating

**URL:** <https://forum.inductiveautomation.com/t/ignition-report-creating/91792>\
**Category:** Ignition\
**Tags:** scripting, reporting\
**Created:** [June 13, 2024, 1:19am UTC](https://forum.inductiveautomation.com/t/ignition-report-creating/91792 "2024-06-13T01:19:30Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![kugan.puspanathan](https://avatars.discourse-cdn.com/v4/letter/k/a9a28c/32.png) [@kugan.puspanathan](https://forum.inductiveautomation.com/u/kugan.puspanathan)\
**Post date:** [June 13, 2024, 1:19am UTC](https://forum.inductiveautomation.com/t/ignition-report-creating/91792/1 "2024-06-13T01:19:30Z")

</div>

Hey everyone,

I currently have a report with 3 different sections.  
**Sections**

1. Title page
2. A table which shows status for pallets
3. A table which shows alarms triggered for the current day

As we know the tables for sections 2 and 3 will create multiple pages until they have filled all data from their respective queries.

I'm looking at making dynamic table of contents section between section 1 and section 2. Which can help jump to section 3 without having to navigate through section 2.

the table of contents would look like below.

**TABLE OF CONTENTS**  
pallet status 2---13  
alarm status 14--17

Any ideas if this is possible ?

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [June 13, 2024, 2:51pm UTC](https://forum.inductiveautomation.com/t/ignition-report-creating/91792/2 "2024-06-13T14:51:36Z")

</div>

Making the table of contents is easy enough with a script datasource, the hard (well, impossible) part is a link that allows the user to go directly to the page they want. The library we use just doesn't have that functionality.

---

<div class="post-metadata">

**Author:** ![Noah\_Casey](https://avatars.discourse-cdn.com/v4/letter/n/e480ec/32.png) [@Noah\_Casey](https://forum.inductiveautomation.com/u/Noah_Casey)\
**Post date:** [June 13, 2024, 3:07pm UTC](https://forum.inductiveautomation.com/t/ignition-report-creating/91792/3 "2024-06-13T15:07:04Z")

</div>

I saw a similar post here:

> [@PDF report linking](https://forum.inductiveautomation.com/t/pdf-report-linking/18860/2):
>
> You completely nerd-sniped me with this topic - I definitely shouldn’t have spent as much time on this as I did. But, this is actually possible with the existing reporting module. We’ll definitely have to see about adding this capability in a better way. Basically, the workaround I came up with relies on the fact that objects in reporting can be copied to the clipboard and show up as XML representations of the underlying Java object. So, to use this (extremely janky) workaround: 0. Paste the s…

Looks like PGriffith found a method to have clickable links, but it only works on the first page of the report also I'm not sure how this would work with a dynamic table of contents in the way that he created this method.

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [June 13, 2024, 4:20pm UTC](https://forum.inductiveautomation.com/t/ignition-report-creating/91792/4 "2024-06-13T16:20:03Z")

</div>

Yeah, the clickable link wasn't the part that worried me, it's getting the link to know what page to go to. The link would be created before the page the data is on....

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [June 13, 2024, 4:48pm UTC](https://forum.inductiveautomation.com/t/ignition-report-creating/91792/5 "2024-06-13T16:48:17Z")

</div>

It might be possible to adapt RM's built in table of contents support:

> [@Report Dynamic Table of Contents](https://forum.inductiveautomation.com/t/report-dynamic-table-of-contents/30576/3):
>
> Huh. Wow. So, turns out this is also possible. Adapting from [ReportMill - Table of Contents](http://www.reportmill.com/support/TableOfContents.html) 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 …

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [June 13, 2024, 5:02pm UTC](https://forum.inductiveautomation.com/t/ignition-report-creating/91792/6 "2024-06-13T17:02:46Z")

</div>

Neat! Also, not it! 😉
