Does the ReportServer page show when viewed in a browser (as below)?

If you haven't changed this from the default, it should be pointing to http://chris-pc/ReportServer not http://chris-pc/Report%5Bb%5Ds%5B/b%5DServer - did you change this?

If deploying to

If the parameter is a drop-down box with the data type set to Integer and the value is the Inventory number you're after, try

WHERE (@report = 4)

If you the parameter...

This isn't something I've seen before. Are you able to create a copy of the report using test data? Let me know if you would like instructions on how to...

Apologies for not responding to the answers here faster. You've all convinced me that the approach I'm going for with row based programming isn't the best practice. I had chosen...

Thanks for this Daniel - it did exactly what I was after! I'll save this blog post for later 🙂