Very Computer

I have what I believe to be a simple question about Foxbase v2.6, and
I'm hoping someone knows the answer or can point me to the right place
for the answer.

I have two seperate reports that work off two seperate databases.
What I want to do is pass the number of pages from the first report to
the second report, increment by one, and start printing the second
report with that page number.

The Langauge specification guide talks about a page count variable,
but says it's for backwards compatability only.

Does anyone have any suggestions?

        Lee

+---------------------------+----------------------------------------------+
| Lee C Brink                Office Support Co-ordinator at NPAC           |

|                            315-443-1722                                  |
|                                                                          |
| Please send email to the above address and not to "mailbox.syr.edu"      |
|       I check that account at most once a week                           |
|                                                                          |
| Note: I will post email if appropriate and/or offensive.                 |
|       You have been warned                                               |
+---------------------------+----------------------------------------------+

...snip...snip...

Quote:>I have two seperate reports that work off two seperate databases.
>What I want to do is pass the number of pages from the first report to
>the second report, increment by one, and start printing the second
>report with that page number.

One appraoch you might take is to use functions as report variables. For
instance, you can put a text variable in the page footer. In the "REPORT
EXPRESSION" for that, put something like SAVE_PAGE(). In your function lbrary
(SET PROC TO) put a function called "SAVE_PAGE" which increments a PUBLIC
variable.  In the second report, put another function GET_PAGE() in the
header which would reference the PUBLIC variable, increment it and print it
as the page number.  

Good luck!

= Mike =

Sent from Oregon Telcom

Quote:>I have two seperate reports that work off two seperate databases.
>What I want to do is pass the number of pages from the first report to
>the second report, increment by one, and start printing the second
>report with that page number.

I think I know a solution which works with Foxpro, I am not sure it will
work with Foxbase.

There is indeed a variable called _pageno which should (most of the times,
but because of bugs in 2.6 not always !) be incremented for each printed page.
What you can do is initialize a variable like m.mypagenr, and put in the summary
page of the first report an expression which calls a function. This function
will store the current value of _pageno (last page!) in m.mypagenr.

The expression which displays the pagenumber in the second report should be
calculated like m.mypagenr+_pageno.

Example:

Procedure print_report
private mypagnr

m.mypagenr=0

report form report1 to printer  && calls calc_page()
report form report2 to printer

return

procedure calc_page
m.mypagenr=_pageno
return ""     && Otherwise .T. will be printed in your report !

Good luck