Instead of creating multiple flags, create a new dimension describing the status or outcome of the inspection. This new dimension could have values like: New, Operational, Some wear, Schedule repair,...

Based on your description, I believe your problem is that you try to put everything into one fact table.

The inspection is one fact table, with the grain being one row...

Maybe the start action is set to a specific package?

Check Project properties\Debugging\Start Action\StartObjectID

Is it set for <Active Package>?

Workaround:

Fetch the LastUsedNumber in your control flow, store it in a variable, and either:

A) pass it into your data flow source as a parameter

B) Create the SQL statement as...

I would make the query return the proper groupings instead of trying to do it inside your report.

Sample query to break your dates into half-years:

Select halfyear, base_name, COUNT(base_name) as...

The "Percent Rejected Dashboard Report" from Brian Larson's "Delivering Business Intelligence" book might do the trick for you. The report will show one Client per row with a column for...

Yes, you can use SSRS to display text files. The term you should be googling is resource.

A resource is a managed item that is stored on a report server, but...

Use this expression in your header textbox: =First(ReportItems!CompanyName.Value)

Where CompanyName is the textbox in your tablix displaying company name

I made the assumption that when you clicked in the matrix report the action was to open the dashboard report, you add the parameter passing in the same tab where...

Try this:

Add RAG parameter to other report.

Add your Switch expression to the BackgroundColor property for your textbox, using the RAG parameter as the switching value.

Pass month RAG value from...