op 26-05-14 13:47, Reinier Olislagers schreef:
(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.
This works fine in Lazreport, but it's not what I want. I want all data,
including details, of the master-record on one line.
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.
This should work in Lazreport, but that's just a case of a masterband.
The point is then : what's the cross-data band used for ? How does it work ?
Anyway, thanks for your input.
B.T.W. I'm using Firebird as a database.
Koenraad.
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
