[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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/