I have a requirement to burst a report to multiple people.
Example: List with 3 columns:
director - manager - total sales
The client wants to burst on both the director column (goes to all directors), and the manager column (goes to all managers). They want to keep all of the columns regardless of who gets the report.
Any ideas? I set up two separate burst tables for manager and director separately, but I can't add both joins when defining the burst options for the report. My only other option seems to be making a copy of the report and setting one up for director and one for manager.