Merge or consolidate report in Ignition

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?

Sounds like you need a third report.

1 Like

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.

1 Like