[Lazarus] Lazreport master-detail on one line

[Koenraad Lelong]

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.