Using Temp Tables in Jaspersoft Studio

[michelle_4]

I have a query that requires temp tables.  The tables need to be created, then indexed, then joined, and then finally I can select my final report data.

When I do this in Jaspersoft Studio I get the error "No results were returned by the query"

I tried writing the query with CTEs instead but the performance is unmanageable- taking over 15 minutes on some of my larger data sets where it takes less than 20 seconds for the same data sets with the temp, indexed tables.

I'm running against a postgres database so the NOCOUNT ON trick isn't working either.

I can see that this issue has been brought up quite a bit in the last few years- are there any good answers for this yet?

Thanks

 

[christopher_5]

2016, same problem here, any solution?