I have a Query linked to a Report in Reports Server and I can see from the Tomcat logs that the SQL query is being run. However, the report doesn't display any results.
If I put the same query into a <queryString> element within the JRXML file, I do see results.
Why would the same query work differently when using a Query compared with using a <queryString>?
Thanks hozawa but the only place I see in JSS where you can link a report to a Query held in a server's repository is when you publish it to the server and you are asked to choose a Datasource or a Query. But I don't see an option to preview it there. How do I link a report to a remote Query before publishing the report?