# Merge or consolidate report in Ignition

**URL:** <https://forum.inductiveautomation.com/t/merge-or-consolidate-report-in-ignition/84170>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [January 12, 2024, 8:09am UTC](https://forum.inductiveautomation.com/t/merge-or-consolidate-report-in-ignition/84170 "2024-01-12T08:09:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lina\_Su](https://avatars.discourse-cdn.com/v4/letter/l/7ba0ec/32.png) [@Lina\_Su](https://forum.inductiveautomation.com/u/Lina_Su)\
**Post date:** [January 12, 2024, 8:09am UTC](https://forum.inductiveautomation.com/t/merge-or-consolidate-report-in-ignition/84170/1 "2024-01-12T08:09:23Z")

</div>

I'm facing a scenario in my business where I need to generate and distribute reports in a specific manner using Ignition's reporting and scheduling functions. Here's the situation:

Individual Reports:

I have two separate reports: Report A and Report B.  
Report A needs to be sent to User A, and Report B needs to be sent to User B.  
Consolidated Report:

Additionally, I need to create a consolidated report that combines elements from both Report A and Report B.  
This consolidated report then needs to be sent to the boss of User A and User B.  
The challenge is that Reports A and B are individual and cannot be merged at the data level due to their distinct nature. My questions are:

How can I effectively set up this reporting and distribution system in Ignition?  
Is there a way to create a consolidated report in Ignition without merging the data at the database level?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [January 12, 2024, 1:17pm UTC](https://forum.inductiveautomation.com/t/merge-or-consolidate-report-in-ignition/84170/2 "2024-01-12T13:17:26Z")

</div>

Sounds like you need a third report.

---

<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:** [January 12, 2024, 3:44pm UTC](https://forum.inductiveautomation.com/t/merge-or-consolidate-report-in-ignition/84170/3 "2024-01-12T15:44:22Z")

</div>

Is it an acceptable variation on your task to email Boss both reports as separate attachments?

Easy to do that with a scheduled script, system.net.sendEmail, and system.report.executeReport to generate the two distinct reports.