I was having the same issue until I found this article. It explains how to use property binding in runtime.

So I went ahead and used the same idea:

1. Add a new parameter to your report with the deployed path (I had to do this to avoid dealing with deployment issues with report designs, so I have a property bound to the deployment profile in maven to do the trick)

2. Use that parameter on the Property binding tab in the Data Source

3. Now it works on both the IDE and tomcat

I hope this works for you as well.