lastly, I've had the issue where it was cleared up by creating an internal variable within the stored proc behind the report, and passing in the input to the internal...

I am going to offer an alternative for you, that I think is a lot more readable/understandable.

First, note the DATEFROMPARTS() function, which you would use since you're...

Admingod, see my similar question on Ask SSC: https://ask.sqlservercentral.com/questions/146178/how-to-use-like-when-multiple-patterns-need-matche.html

Des, would be interested in your input there too.

not exactly what you are doing, but might be helpful: https://morecomputerstuff.wordpress.com/2015/05/20/running-batch-ssrs-sql-server-reporting-services-reports-using-powershell/

Ask the end users to help verify, distribute the workload

you want to run them on the reportserver, or could you just run the stored procs that are feeding the reports and compare that way?

You Shall Not Pass..............un-parameterized user input directly into strings without using sp_executesql properly!

Little known fact, if Sauron had only used a backup for his One Ring, it would...

I second Julian's recommendation, as someone who wants to learn, I don't just want to know that something is possible if it's a bad idea, I want to know that...

Hm, thanks for the lesson on sorting too, very true, had not considered that. Maybe I can avoid that trap now!