robert.baldock

I'm not getting quite the same thing. I don't have any warnings or errors, in fact I can see in the logs that the query is being run and seems to return the expected number of results: 2015-10-01 08:15:09,631 DEBUG ColumnDataCacheHandler,pool-4-thread-21:341 - Recorded cached data source of 2 records 2015-10-01 08:15:09,632 DEBUG ColumnDataCacheHandler,pool-4-thread-21:209 - adding cached data of size 0 for for [{datasetUUID:8a465670-cc4a-4270-965f-8efb86e33b71,queryMD5:d41d8cd98f00b204e9800998ecf8427e,},{subreportUUID:795a7626-f924-438e-ab9e-809a9bfe5c70,rowIndex:2,datasetUUID:8722a75e-dde5-4f2d-ad94-e1ec777a54d7,}] 2015-10-01 08:15:09,632 DEBUG ColumnDataCacheHandler,pool-4-thread-21:209 - adding cached data of size 2 for for [{datasetUUID:8a465670-cc4a-4270-965f-8efb86e33b71,queryMD5:d41d8cd98f00b204e9800998ecf8427e,}] 2015-10-01 08:15:09,632 DEBUG ThreadPoolSubreportRunnerFactory,pool-4-thread-21:90 - shutting down java.util.concurrent.ThreadPoolExecutor@27202a40[Running, pool size = 1, active threads = 0, queued tasks = 0, completed tasks = 1] 2015-10-01 08:15:09,632 DEBUG AsyncJasperPrintAccessor,pool-4-thread-21:256 - report finished However, I also see these entries in the log: 2015-10-01 08:15:09,626 DEBUG JRVerticalFiller,KHUB Report 1 subreports #1:135 - Fill 2: no data2015-10-01 08:15:09,627 DEBUG JRVerticalFiller,KHUB Report 1 subreports #1:211 - Fill 2: no pages Which is presumably why the report is displaying a blank page. Robert

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? Robert

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>? Robert

When I bring up the Dataset and Query dialog in JSS, I can see a list of local data adapters but it doesn't show any of the adapters in the server repository I am connected to. Is there any way to connect a dataset to a remote data adapter using this dialog? Robert

I'm having problems linking a Query in the repository to a report created in Studio. If I hard-code a SQL query in the JRXML file with <queryString>, I get results displayed in the report when I publish it to the server. However, if I remove the <queryString> element and try to link the report to a Query in the repository (which contains the same SQL string) using the UI, I get no results. Why might this be? As a possible way round this, is there a way to refer to a Query by its ID in a JRXML file using <queryString>? Robert

Thanks @hozawa. I know I could just re-create the report in Studio but I have a whole set of reports that were created in the Enterprise Edition and I was hoping there would be some way to retain the layout of each report when migrating them to a Community Edition instance. Robert

What's the recommended way to migrate a .jrxml file for an ad hoc report into the Community Edition of JasperReports? In particular I need to change entries like this in the subDataSet element: <parameter name="_dbo_ActivityCountByMonth.CreatedYear3_AdHocFunctionMask" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[AdhocEngineServiceImpl.getInstance().getDefaultMask("java.lang.Long", $P{REPORT_LOCALE}, $P{REPORT_TIME_ZONE})]]></defaultValueExpression> </parameter>[/code]So that instead of using AdhocEngineServiceImpl they use a corresponding class supported by CE. Robert