Has the report's data source been updated?  I would assume if the DB isn't where it used to be that will need to be done.  Also, does the report user...

I would use a NOT EXISTS to exclude the records with a type 2, and then UNION that to a query that only picks up type 2, like this:

I don't know about videos, but the Stairway to SSRS on this site is a nice introduction.

In your screen shot it looks like the report that came up blank in SSRS was for "1 Day Fishing - All Species" licenses.  Are you sure there is data...

Just to toss it out there, you could potentially also use PARSENAME here:
SELECT PARSENAME(MachineNAme, 3)
FROM dbo.Failed
WHERE PARSENAME(MachineNAme, 3) IS NOT NULL

In my limited experience, I have found reports with subreports are poor performers in general.  First make sure the subreport queries are fast and returning no more fields than they...

You might be able to achieve it using report items, which allows you to refer to the value in calculated report boxes.  The format for your expression would be something...

As a complete aside, here's a tip I learned from Kendra Little.  These two commands from Steve's script:
SET STATISTICS IO ON;
SET STATISTICS TIME ON;
Can be...

Are you able to run the report in SSRS, or does it always ask you for credentials?  In setting up the custom data source, did you check the Use Windows...

It sounds like there's a one-to-many relationship between customer and codes.  What do you get if you add a DISTINCT to your counts, like count(DISTINCT o.OrderID) ?

If you have the enterprise edition of SSRS, you can do it with a data-driven subscription: https://msdn.microsoft.com/en-us/library/ms159150.aspx
Part of the setup allows for a conditional query, where the subscription...

In Piet's code, try replacing the last line:
WHERE rn = 1

[p][/p]
with something like this, using Modulo:
WHERE rn % 10 = 0

You can define the interval for each axis in the Axis Properties. Click on an axis and it should draw a box around the values. Now right click...

On the SQL tab they are usually sorted by the ones that took the longest/had the most Waits associated. I start there.