I hate to be ugly, but I really think you're over your head on this one.  E-mail Albert Kallal and see. He wrote about designing something very similar on the...

Albert Kallal wrote one of these several years ago. Or one very similar to this. Not sure if he used SQL Server as a back end, although he might have.

Sounds like homework. Pretty sure you're supposed to do it yourself.  Try it and ask if you don't understand something.

Do you mean as HTML? "This format" and showing a picture doesn't really help.

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...