And what do the error and event logs say?

Personally, i would go with a bunch of ORs or an IN. Using Joe's Sample Table:

What have you tried so far? Have you checked the documentation? https://docs.microsoft.com/en-us/sql/relational-databases/databases/attach-a-database?view=sql-server-2017 Have a go and if you get stuck tell us more about what the problem your facing...

What do those logs say that the error tells you to look at?

I can't test this, however, I think the problem is the location of your CAST. You need to CAST one of your columns to a BIGINT before calculating your expression,...

What exactly is your question here? You say you're looking for an alternative to checkpoints, so what functionality, instead, are you looking for if not a checkpoint?

I can't find a specific article, or document, that states, so, however, a simple Google of "ssrs subreport header not showing" returns a lot of posts from others giving the...

Don't post images, post data as text. See the link in my signature on how to post sample data and expected results, and it'll be much easier for someone to...

Unless I recall incorrectly, and I'm pretty sure I'm not,header and footers are not displayed in subreports. I'll see if I can find something that confirms this.

This is a quite a simple query in terms of SQL. What have you tried so far? You'll learn more by researching rather than someone simply giving you the answer.

Yes, there is! Use several file system tasks, or a loop with a changing variable value.

Also, there's no need for that huge CASE expression you have to get the quarter. DATEPART(QUARTER, GETDATE()) will do exactly the same thing.