Buttons - Linked Reports - Parameter Prompt - Export Straight to XLSX

Good day! For my users, there are three related reports that are run in a relatively quick sequence as soon as each completes. To help manage some of the time cost of switching back and forth between different reports, I'm attempting to provide three buttons within the same report. What I'm wanting to have happen, is when each button is clicked, a popup with the parameters is displayed and then when run, the report is executed and downloaded without leaving that page. So when this is completed then they can just click the next button for the next export that is needed to export.

All that said, I can use the append option to ensure the reports exports when the button is clicked, however, it redirects to the parameter page so the user has to click back to go back to the original report to continue with their process. If I add the popup option as well, then I stay on the same page once the linked report executes but it tries to display the xlsx output in the popup window rather than downloading the output.

Can you provide me with any suggestions on how to achieve my goal?

BEGIN
BEGIN
SELECT 'dbr.button','TIN PROVIDER PROFILE';
SELECT 'dbr.report','sp_DBR_Profile_TIN','append=&export=xlsx','popup';
SELECT 'dummy result set for the button';
END

BEGIN
SELECT 'dbr.button','NPI PROVIDER PROFILE';
SELECT 'dbr.report','sp_DBR_Profiles_NPI','append=&export=xlsx';
SELECT 'dummy result set for the button';
END

BEGIN
SELECT 'dbr.button','MBR PROFILE';
SELECT 'dbr.report','sp_DBR_Profile_Member','append=&export=xlsx';
SELECT 'dummy result set for the button';
END
END

Hi,
the closest you will get if you set the target to be 'new_window'. This will open the report in new window allowing for you to enter the parameters and execute the Excel-file download. It will leave you the window open which you need to close, but the original report with the three buttons would stay in place.