Detail In Sub report

rbuser

I have a report that consists of three different Queries
Query1 :
Select hourly Data : Placed in detail band of Report

Query2 :
Select Day Total from another table Placed in summary field

Query3 :
Select Data From a third table That is used to summarize the hourly data
per shift, This summary can contain 3 to 4 records

The First two queries results are returned correctly, as is displayed as
such.

The problem arises in the third query, this is a subreport and show only the
first record of the returned set.
If the Query is Run with Query Analyser the correct results are returned.

Edward Potgieter

Product Delphi 6 SP2
Reportbuilder 6.0.3

digitalmetaphors

This sounds like the data pipeline might not be hooked up to the subreport.
If autostop is true in this case, then it will print in the way that you
have described- one record even if the dataset has more than one record in
it. Make sure autostop is set to false on the subreport as well as checking
the query->datasource->datapipeline->subreport connections.


Cheers,

Jim Bennett
Digital Metaphors