I recently replaced many Jasper reports with FastReport.
This is a factor 100 times faster. A 100 page overview is created in 1 to 2 seconds (instead of 2 to 3 minutes).
It is used as a standalone report writer against the DB.
The report-definitions are stored as XML-files, so it's easy to search and replace source-code.
There are 2 businessrules in AwareIM:
Rule 1:
CREATE Temp
Temp.Input=SystemSettings.DatabaseName + ' ' + LoggedInBackofficeUser.LoginName + ' ' + 'listpersons'
Temp.Output='c:/temp/' + SystemSettings.DatabaseName + '/listpersons.pdf'
EXECUTE PROGRAM 'dofastreport.cmd ' + Temp.Input
Rule 2:
IF FILE_EXISTS (Temp.Output) = 'Yes' THEN
IMPORT DOCUMENT Temp.Reports FROM Temp.Output
DOWNLOAD DOCUMENT Temp.Reports DELETE AFTER 15
In "dofastreport.cmd" the exe is started using some parameters which have to be defined in de source from the report (listpersons.fr3).
fastreport c:\awareim_projects\fastreport\%3.fr3 /EXPORT=c:\temp\%1\%3.pdf /Param="databasein=''%1'';userin=''''%2''''"