Re: using subtotals from arrays

[Sam Parks <sam.parks@ORC-SIRS.COM>]

-----Original Message-----
From: Ray Ontko [mailto:rayo@ONTKO.COM]
Sent: Friday, October 22, 1999 9:41 AM
To: Multiple recipients of list SQR-USERS
Subject: Re: using subtotals from arrays


Walter,

Unfortunately, there is no "ON-BREAK" functionality for arrays.
You _COULD_ write the data to a temporary table and then query
it using SQL, but I would just code the break logic by hand.
You know, the old way:

   if $department <> $old_department
      do something
      move $department to $old_department
   end-if

Ray

> I am attempting to create a report which uses data from arrays.  However,
> beyond performing a preliminary sort on that array, how can i list
> information, say by department, and then show within that dept group, sort
by
> emplid?  To me, it is analogous to nested print on-break print=never
> after=etc.
>
> the environment is sqlserver, peoplesoft v7.5
>
> any comments would be appreciated
>
> walter dong
>

----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/