Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cesar
  Where is Cesar?
 
 Brazil
 Cesar
 To: Garth Groft
  Where is Garth Groft?
 York
 Pennsylvania - United States
 Garth Groft
 Tags
Subject: RE: FoxyPreview Report Page Numbering
Thread ID: 345336 Message ID: 345344 # Views: 56 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Reports and Printers
Date: Tuesday, May 22, 2012 6:57:57 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

Does the same problem happen if you run these reports using SET REPORTBEHAVIOR 90 ?

Regards,

m.Cesar
My Blog

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