Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

sql problem

edited September 2003 in End User
Hi,
I'm using ReportBuilder Enterprise Edition and what I want to do is creating
a master. In this master I use a sql statement wich returns user data in the
footer.
Now, my problem is that when I add an new sql statement in ReportBuilder I
always get only one row of data instead of multiple rows.
How can I handle ReportBuilder by using two different sql statements? The
sql statements don't depend on each other.

Thanks

Claudia Kleber

Comments

  • edited September 2003
    Hi Claudia,

    For ReportBuilder to traverse a dataset, it needs to be connected to a
    datapipeline (or datamodule in DADE). If you wish to connect to multiple
    datasets, you will either need to link your datapipelines/datamodules or use
    subreports with the Report.Data property set to the proper datapipeline.
    You can set the data property in ReportBuilder by selecting the Report |
    Data option in the designer menu.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.