• Resolved it.

    Found this on SQLCentral. (didn't pop up in my google searchs 🙁 ) which is 80% of what i wanted. I redid my report again using this and it worked...

    http://www.sqlservercentral.com/blogs/sqldbauk/2011/07/22/ssrs_3A00_-dynamic-data-sources/