This sounds silly but I can't find or get working a way to export a report from a button.
I have a simple report that outputs the contents of a db table and I have saved it with its Output Format as Excel.
I've included the following in the body of another report:
select 'dbr.report', 'sp_DBR_Sched_Export';
select 'dbr.button', 'Export Schedule Data';
When I click the button the export report opens over the initiating page whereas I was expecting to just get the Save As dialogue.
Is this possible?