I found out the proble. I was using a mapped drive in my connection string and not the full connection string. Once changed the report worked fine.