I have a client who has manually been running a report for a long time, in excel. They run an SQL stored procedure that returns 2 datasets from two different tables. The client then manually copied and pasted the two result sets into tabs in excel, and in the 3rd tab created a pivot to show the data by month. I am trying to convert this to an automated report, however the first thing I learned was SSRS doesn't like multiple data sets, and only takes the first while ignoring the second.
How should I proceed?