Test the Burst Calculation
Manually test your report by right clicking and bursting a selected row(s) or by choosing Burst Selected Rows from the Bursting dropdown menu. If Show Target reports is still checked in the burst dropdown menu or within the burst calculation during testing, a new window should open showing the relevant target or sub-report. Also valid values matching your report parameters on the sub-report pass through criteria will appear, e.g. report by BU 1, as we established earlier. Obviously, Automator ignores the Show target on run when it process a report, but you must have Burst on Run selected.