I created with rawSql a temporary table (create table TEMP XXX ...) containing a series of data for then print it from Jasper.
As Jasper only supports foundset and not dataset, I tried to create a temporary table and load it the result of the dataset.
- Code: Select all
...
var _dataset=databaseManager.getDataSetByQuery(_SQL);
fsTmp = databaseManager.getFoundset (szServer, "XXX");
fsTmp.loadRecords (_dataset)
...
The problem is that it fsTmp=null and fsTmp.loadRecords (_dataset) returns an error.
Is there no way to create a temporary table foundset? Can we send to Jasper a dataset instead of a foundset?
Thanks.