• ok, so just thought i would share this. My reports are now working after reading and following this tutorial:

    http://www.mssqltips.com/sqlservertip/2373/how-to-handle-empty-values-in-a-line-chart-in-ssrs/

    Apparently the problem was that the data wasnt continuous. It works fine now though.