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

You can't do a multi-select match with = in your filter.  Right-click your dataset, and go to Dataset Properties.  Under the Filters tab, you need to change the operator in...

general rule of thumb with aggregates / GROUP BY.

Columns in the SELECT clause must be either aggregates (Sum, Min, Max, Avg...etc) OR they must be in the GROUP...

SSIS package to get the file (download), then import the text file. Then schedule it using a job?

If you added the calculated field to your dataset, then you can use it just like a normal field (as it if were in the original dataset). If not, I...

How long is a piece of string?
Is this a one-off or do you need to import different files with the same structure?
If it's a one-off you can use...

I'm using SSRS 2016, but I'm pretty sure this is still the same.
Open your report, and switch to design mode.
Then go under the Report menu to Then...