Fast reports

Contains tips for configurators working with Aware IM
Post Reply
jannes
Posts: 109
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: 1162
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
MESSI
Posts: 50
Joined: Thu Dec 29, 2022 11:09 pm

Re: Fast reports

Post by MESSI »

jannes wrote: Sat Jul 27, 2024 10:25 am 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).
Besides me, I think many of us are interested in this topic.
Can you provide which version have you used?Paid? Free?

Thank you
AwareIM , 8.8, 9.0 - MariaDB, Windows Server 2012,2019, 2022 Standard
kklosson
Posts: 1667
Joined: Sun Nov 23, 2008 3:19 pm
Location: Virginia

Re: Fast reports

Post by kklosson »

If jannes is willing to provide a 30-minute webinar on Zoom or any other platform, I would love to see it.
V8.8
MySQL, AWS EC2, S3
PDFtk Toolkit
Heavy on AwareIM Reports
customaware
Posts: 2433
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Fast reports

Post by customaware »

Or do a presentation at the India Conference. 😉
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
kklosson
Posts: 1667
Joined: Sun Nov 23, 2008 3:19 pm
Location: Virginia

Re: Fast reports

Post by kklosson »

MESSI, can you tell us whether Fast Reports supports conditional elements is some manner like the internal report generator? I looked at their documentation, but I don't see it.
V8.8
MySQL, AWS EC2, S3
PDFtk Toolkit
Heavy on AwareIM Reports
MESSI
Posts: 50
Joined: Thu Dec 29, 2022 11:09 pm

Re: Fast reports

Post by MESSI »

kklosson wrote: Sun Dec 15, 2024 6:26 pm MESSI, can you tell us whether Fast Reports supports conditional elements is some manner like the internal report generator? I looked at their documentation, but I don't see it.
I haven't dived down into it yet. I am comparing few options here: FastReports, Jasper Reports, and googling for others.
I will let you know what we have chosen for the reporting part.
Thank you
AwareIM , 8.8, 9.0 - MariaDB, Windows Server 2012,2019, 2022 Standard
ACDC
Posts: 1162
Joined: Sat Jun 30, 2007 5:03 pm
Location: California, USA

Re: Fast reports

Post by ACDC »

I am keen on the Devexpress offering, have you checked it out
https://www.devexpress.com/subscriptions/reporting/
Post Reply