[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