sql problem
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
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
This discussion has been closed.
Comments
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.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com