mORMot Open Source

lele9

Member

Registered: 2011-10-28

Posts: 170

pass data to report

hi,
maybe my question is stupid...
before mormot framework i use dataset in my application, now i rewrite my code with this framework and its great.
Before i use fastreport with dataset to access the data, now how is the correct way to create report?can i use fastreport too?how can i pass data to the report?i must create dataset?
Thanks a lot and excuse me for my poor english.
Emanuele

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,667

Website

Re: pass data to report

You can use FastReport if you want to.
You could create an in-memory dataset with data from mORMot (you'll have to create the join manually).
Or use the OnData-like events of the report - but I do not remember how it works.

From the framework point of view, there is the SQLite3Pages unit which is dedicated to report creation.
There are some methods available to work directly from the ORM objects.

See TFileRibbon.CreateReport method in MainDemo\FileClient.pas, and the associated TSQLRibbon.CreateReport / TSQLRibbon.AddToReport methods in SQLite3ToolBar.pas.

There is some presentation of the reporting features of mORMot in the documentation.
See the SAD document, page 605ss ("1.5.4.4. Report generation").