Fast reports

Contains tips for configurators working with Aware IM
Post Reply
jannes
Posts: 103
Joined: Tue Jul 02, 2019 12:22 pm

Fast reports

Post by jannes »

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''''"
ACDC
Posts: 1154
Joined: Sat Jun 30, 2007 5:03 pm
Location: California, USA

Re: Fast reports

Post by ACDC »

Interesting, I would like to know more.
Can it do grouping similar to the current AIM grouping in the Kendo Grid
Also, I see there is a free version, is this the same?
Can you embed the report inside the AIM perspective ?

Would love to see a more detailed implementation steps
Post Reply