James
There are others out there that understand this better than me - but, for
what it's worth, I think you do this.
In the first part of the report use a Sub-detail band as the basis of your
grouping and referencing its own dataset.
In the final part of your report use another sub-detail band referencing
another dataset. If you use TQuery's you can do the aggregating in the
Query.
Hope that helps get you on the right track
Mark
----- Original Message -----
From: James Sugrue <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Sunday, July 16, 2000 11:44 PM
Subject: RE: [DUG]: Sub Reports
> I didn't explain it that well so I'll try again.
>
> I have a report which shows the Gross Profit figures for a group of
stores.
> It shows :
> This Week, This Week Last Yr,Ytd, Last YTD and some other data.
>
> At the end of the report I need show the average values of the above data
> for each store.
>
> Is there anyway to do this in Quick Reports?
>
> -----Original Message-----
> From: Nello Sestini [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 17 July 2000 16:11
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: Sub Reports
>
>
> >I can get the data I want if I put it in a Sub-Detail band, but it prints
> >the data after each record of the Detail band which is not what I want. I
> >want to show the Sub Detail band after all the records in the Detail band
> >have been printed.
>
>
> you could try showing the (whatever) in a Group footer band.
>
> Set the Group expression to something that will change when you want
> a break in the detail lines.
>
> (hope this is what you meant)
>
> ns
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
>
>
> CAUTION - This message may contain privileged and confidential information
intended only for the
> use of the addressee(s) named above. If you are not the intended
recipient of this message you are
> hereby notified that any use, dissemination, distribution or reproduction
of this message is prohibited.
> If you have received this message in error please notify Progressive
Enterprises Ltd. immediately via
> email at [EMAIL PROTECTED] Any views expressed in
this message are those of the
> individual sender and may not necessarily reflect the views of Progressive
Enterprises Ltd.
>
> This footnote also confirms that Progressive Enterprises Ltd. has swept
this email message for the
> presence of computer viruses. This does not guarantee this message is
virus free.
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
