How to upload an SQL query to SSRS that returns 5 tables, ensuring that when the report is exported to Excel, these tables appears on separate sheets
Our reports, written in MS SQL, need to be uploaded to SSRS, allowing coworkers to generate them with different parameters and export SSRS reports to Excel files. We typically create stored procedures with parameters and use them in SSRS reports.