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?