• Thank you for the response, that sounds like a good thing to test... We have a lot of subscriptions, so I was thinking that the auto size on ReportServer & ReportServerTempDB but it looks good... I think it is the report parameters that are gathering data from small datasets, which means each time I change date for example the report subscription is gathering data from those datasets each time... Reports that don't have as many parameters seem to come up faster...

    I did hear a solution (if you want to call it a solution) from a Microsoft that this was a chance to use data driven subscriptions... To me that's not a solution it's a work around... Microsoft really needs to fix this because not all of us have the access and/or the room to create a dataset for a data driven subscription...

    Thank you for your response