Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Garth Groft
  Where is Garth Groft?
 York
 Pennsylvania - United States
 Garth Groft
 Tags
Subject: FoxyPreview Report Page Numbering
Thread ID: 345336 Message ID: 345336 # Views: 57 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Reports and Printers
Date: Tuesday, May 22, 2012 5:55:22 PM         
   


I am experiencing a page numbering problem when using FoxyPreviewer to append a second report to a first report (using NORESET parameter). The first report is being numbered 2 and the second report is numbered 1. i am using _pageno for page numbering. Report content is perfect in both FoxPreviewer and VFP preview. Page numbering is fine in VFP preview - two separate reports in their own preview windows.

*!* set up cursor for unit_quotation report
IF NOT USED("Options")
USE SYS(5)+ CURDIR() + "custdata\hav001\options.dbf" IN 0 SHARED
ENDIF
SELECT Options
SET ORDER TO TAG Dpidseq
LOCATE FOR domain = units.domain AND pid = units.pid AND seq = units.seq
SELECT SPACE(10) AS domain, SPACE(20) as pid, SPACE(3) as seq,* FROM "options_table_format";
INTO CURSOR optionsprice READWRITE

* run this function to mark the options used by this unit in the optionsprice cursor
Thisform.Options_list_from_opt_fields_price()

SELECT domain,pid,seq,selected,optcode,option,price FROM optionsprice INTO CURSOR optionspricelist ;
READWRITE WHERE selected
SELECT Optionspricelist
REPLACE ALL IN Optionspricelist domain WITH units.domain, pid WITH units.pid, seq WITH units.seq
GO TOP

*!* set up cursor for unit_quotation report
*!* unit_quotation reports on a single unit (current record only) and its associated options as defined ;
in optionspricelist cursor.
thisreport = "Reports\unit_quotation.frx"
IF thisform.foxypreviewer
SET REPORTBEHAVIOR 90
REPORT FORM LOCFILE(thisreport) PREVIEW ;
NOPAGEEJECT NORESET
*!* select table for terms-conditions report
SELECT units
REPORT FORM "reports\terms-conditions.frx" PREVIEW NEXT 1
ELSE
SET REPORTBEHAVIOR 80
REPORT FORM LOCFILE(thisreport) PREVIEW
PUBLIC lastpageno
lastpageno = _pagetotal + 1
SELECT units
REPORT FORM "reports\termsandconditions.frx" PREVIEW NEXT 1
ENDIF

all reports are attached. termsandconditions is the same as terms-conditions except that the latter uses lastpageno instead of _pageno - just trying a different approach.

Garth Groft
https://www.foxite.com/uploads/02932ab6-1a63-4def-8099-7ad7c39344cd.zip

ENTIRE THREAD

FoxyPreview Report Page Numbering Posted by Garth Groft @ 5/22/2012 5:55:22 PM
RE: FoxyPreview Report Page Numbering Posted by Cesar @ 5/22/2012 6:57:57 PM
RE: FoxyPreview Report Page Numbering Posted by Garth Groft @ 5/22/2012 7:28:03 PM
RE: FoxyPreview Report Page Numbering Posted by Cesar @ 5/22/2012 9:59:19 PM
RE: FoxyPreview Report Page Numbering Posted by Garth Groft @ 5/23/2012 2:59:13 PM
RE: FoxyPreview Report Page Numbering Posted by Cesar @ 5/23/2012 3:02:41 PM
RE: FoxyPreview Report Page Numbering Posted by Garth Groft @ 5/23/2012 4:06:14 PM
RE: FoxyPreview Report Page Numbering Posted by Koen Piller @ 5/23/2012 7:15:39 PM
RE: FoxyPreview Report Page Numbering Posted by Garth Groft @ 5/24/2012 4:34:38 PM
RE: FoxyPreview Report Page Numbering Posted by Koen Piller @ 5/24/2012 10:50:56 PM