[Lazarus] Lazreport master-detail on one line
Reinier Olislagers
reinierolislagers at gmail.com
Mon May 26 13:47:29 CEST 2014
(Note: haven't ever set up master/detail reporting in Lazreport, so just
some ideas below)
At least in other reporting solutions, master details means having some
master band, then a detail band below it.
This gives the following setup:
Master1 record
...detail1:record1
...detail1:record2
...
...detail1.recordn
Master2 record
...detail2:record1
...
...detail2:recordn1
In other words, it supports single row reports only.
No idea if this applies to lazreport.
In other reporting solutions, if you want to have master+detail info
next to each other, you can use a query in the database that provides
the info in the desired layout.
This is often known as s acrosstab query, searching gives e.g.
Postgresql
http://stackoverflow.com/questions/3002499/postgresql-crosstab-query
Or
http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=25
Obviously no idea if this applies to lazreport as well.
More information about the Lazarus
mailing list