That gets me closer. However, this report also needs to do yearly comparisons where it will look at the same month a year ago so the T-SQL  might get cumbersome....

That did it. Thanks!

Michael - I'm fairly new to SSRS so I'm not sure what you mean by that. In Reporting Services Configuration Manager --> Database --> Current Report Server Database Credential I...

Thanks, Jeff. That's probably best anyway so that I can draw their attention to it as it happens since a lot of times they don't realize what the size will...

Steve - Are you saying you were able to add fixed header rows after exporting to Excel by using a matrix or are you saying you were able to freeze...

I was thinking of some kind of exceptions list that would allow certain tables to grow over the limit. However, my original post looking for a way to limit the...

Thanks for all of the advice. It sounds like I need to change the way our processes are currently handled.

Thanks. I kind of like the idea of disabling the job and having the proc start the job when it finishes. Like I said, I'm new to SSRS so I'm...

The reason is that some create a table and unintentionally consume a large amount of space. Being able to prevent that from happening would force them to rethink their strategy...

So you are saying if the stored procedure should run at some point between 6 AM - 10 AM then I should schedule the SSRS process to run every 5...

I want to be able to control it at the table level. They should be able to still create/update multiple tables that add up to xGB but not do so...

Eric - That's exactly what I need and was definitely over-thinking it. Thanks everyone for the help!

If I leave those off then it works and that's where I've been getting stuck. I can see it in personal certificates in MMC but I read it needs to...

I've previously attempted to follow that but I get this error when I try to run the command New-SelfSignedCertificate -DnsName <serverFQDN> -CertStoreLocation cert:\LocalMachine\My -FriendlyName test99 -KeySpec KeyExchange 
If...

It tuns out it was a bad disk belonging to another role as part of a separate SQL instance that was causing issues with this install. Once that disk was...