Combining two data sets on one report?

rbuser

I have a form which displays one set of data about a person using query A,
and then another area displays aggregated information based on a complex
query (query Is there a way to have the query A display the header, and
the query B provide the detail without actually having to join the two
queries together?

Hope this is clear?

TIA

Barry

nicocizik

Hi Barry,

Yes... you can create a Master-Detail relationship by linking the two tables
either using Delphi linking or DataPipeline linking. Then by placing a
subreport in your detail band and connecting it to your detail dataset, you
can display all detail data for each master. For examples of Master Detail
reports, please see the ReportBuiler demos located in the
\RBulder\Demos\Reports\... directory. You will want to take a look at
demos 71 - 80 (dm0071.pas ... etc.).

--

rbuser

Hi

My situation isn't a master-detail situation. I guess the second query
would be a "sub-report"? I've never used one before, would this be
appropriate?

Barry