Are you using any parameters in this report? You'll want to make sure that your parameters are pointing to proper fields in your query.
Also, make sure that the resource that you are running the report from in Clarity has the proper security rights in both Clarity and in Jaspersoft.
You might start with a basic query in iReport that has no parameters, like 'select i.id, i.code, i.name from inv_investments' just to make sure that your IDs are set up properly in jaspersoft... then add in joins and parameters one at a time to try and pin-point where the disconnect is occurring.