Re: See data and while we're on the topic of on-break............ ....

[Fatima Bagaria <FatimaB@LIMON.CO.ZA>]

Here's what I need to do:

1. Calculate a total amount for fields with identical ID, Description and
Date
2. Print the ID, Date, Date and Amount.

So.. I need to change:

ID DESCRIPTION DATE          AMOUNT
5  ABC                01/01/2000  500
5  ABC                01/01/2000  500
5 ABC                01/01/2001  100
5 ABC                 01/01/2001  100
6 DEF                01/01/2000   200

So it becomes....
ID DESCRIPTION DATE          AMOUNT
5  ABC                01/01/2000  1000
5 ABC                 01/01/2001   200
6 DEF                01/01/2000    200


Thanx!

 -----Original Message-----
From: Slattery, Chad [mailto:Chad.Slattery@CSCLAC.IRLGOV.IE]
Sent: 06 April 2000 06:23
To: SQR-USERS@list.iex.net
Subject: Re: See data and while we're on the topic of on-break............
....



Fatima,
I dont fully understand your question but have you tried writing a procedure
that will print what you want, you can then call it after the on-break like
so

begin-select
date on-break after=print-proc
end-select

begin-procedure print-proc
print stuff
end-procedure

hth
----------------------------------------------------
More on-break questions

I have a question of my own that Im not sure is possible, when you use
on-break, it breaks at the break field and wont print that field again until
it changes.  Is there any way to keep printing that field and still use the
on-break logic.

eg with an on-break on num1 and skiplines = 1 I get
num1         num2
1               x
                x

2               x
                x

3               x
                x

what I want to get is
num1         num2
1               x
1               x

2               x
2               x

3               x
3               x


Cant seem to find the answer in the book.
Chad.



-----Original Message-----
From: Fatima Bagaria [ mailto:FatimaB@LIMON.CO.ZA
<mailto:FatimaB@LIMON.CO.ZA> ]
Sent: Thursday, April 06, 2000 5:01 PM
To: SQR-USERS@LIST.IEX.NET
Subject: See data


Hi all

Please help!!
I'm new at this as the following will show:

This is a list of records I need to print, BUT I only need to print the
amount once the date changes.



       ID               Description                          Date
Amount
 <<...>>

group by clauses,
if $ID <> &ID
 Let #ind = x
and on-break command have proven useless.
It's obvious that a total needs to be calculated for records with the same
ID, Description and date.
BUT HOW???

All help in securing my job sincerely appreciated..