You don't have PowerShell? Why not download it?

What was it? Please share!

What if you did it using PowerPivot and DAX. There are functions for that. CLOSINGBALANCE stuff, etc. Is that an option?  What did you intend to do with the data....

Got Google?
https://stackoverflow.com/questions/31153523/is-there-any-performance-difference-between-view-and-stored-procedures

Sort of an apples vs oranges comparison. They're used for different purposes. What's your end goal?

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