If the expression you used to segment the records into the 30/70 split is part of your dataset, then it's stupid easy,
Open the report, switch to Design mode,...

If you use COUNT and DATEDIFF() and GETDATE(), you're home free.

Haven't seen the book yet. I went to Robert Cain's presentation on SSRS 2016 at SQL Saturday DC and he covered some of the stuff in the book. He knows...

do you have double-byte characters in your text? If not, you don't need NTEXT at all.

That sounds like an article in the making...
How people do it wrong.... and then how to fix it/do it correctly.

If you build this as a stored procedure, then you can go to Excel, create a connection to your database and execute the stored procedure and bring the data back...

If you just want to learn cursors, then crack open Books Online and read. Write a bunch of cursors.  You basically said "I know cursors are terrible, but I want...

Did you finish Data Warehouse Toolkit and Star Schema: The Complete Reference yet?

Can't speak for anyone else, but without data and maybe a screenshot of your report, it's impossible to say.

Why not use a Calendar table?
http://www.sqlservercentral.com/blogs/dwainsql/2014/03/30/calendar-tables-in-t-sql/

Then you can filter down to what you want (like X number of Mondays), by filtering for the day and using...

He doesn't???  Jeff's code is about the safest stuff out there. What if you printed out the code for it and showed it to him? The code is commented so...

Instead of
SWITCH((Fields!WeekPercentage.Value>Parameters!Percentage.Value) &(Fields!Percentage.Value>Parameters!Percentage.Value) ,"RED","YELLOW")
try
IIF((Fields!WeekPercentage.Value>Parameters!Percentage.Value And Fields!Percentage.Value>Parameters!Percentage.Value ,"RED","YELLOW")

What did you try? This is not a "Please do my work for me" site.  Do it yourself, because you are the one that is going to be supporting it,...

Sounds like use a rectangle and set a page break after
https://stackoverflow.com/questions/3230669/inserting-a-page-break-into-an-ssrs-report