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

Re: any way to jump BACK a page?



Much in the same way SQR prints pages numbers in the format page 1 of 30
you can do this.
What you will need to do is have temp variables that hold the total you
want and one more to tell the procedure to skip printing when you run
through the program the first time.  If this is a fast program this should
be no problem.  Have you main procedure call the other procedures twice.
around your calls to print procedures include code like this

if $print_first = 'Y'
  add #col1 to #tot1
  add #col2 to #tot2
  ...
else
  do print_my_data
end-if

in print_my_data add the line
print #tot1 (,,)
...
in the appropriate place.

An alternative would be to use your database to get the totals, and just use a
begin-select
sum(col1)  &tot1
from Table_one
where ...
end-select

then print the &tot1 in the appropriate places.

Just some thoughts,
there are many ways you can do this!!

Scotty



  At 11:12 AM 7/10/02, you wrote:
> >
>             3
> >                         4
> >                         5
> >                         --
> >                         Total B
> >
> >I'd like the SQR to be able to jump back to the original start page.
> >Is this possible?
> >
> >Thanks!
> >
> >-Andrew
>
>
>
>
>_________________________________________________________________
>Join the worldÆs largest e-mail service with MSN Hotmail.
>http://www.hotmail.com


----------

Scott A Barnes
Programmer/Analyst
Wesleyan University
North College
860-685-2807


----------
Lottery: A tax on people who are bad at math!