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
 To: Cesar
  Where is Cesar?
 
 Brazil
 Cesar
 Tags
Subject: RE: FoxyPreview Report Page Numbering
Thread ID: 345336 Message ID: 345348 # Views: 44 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Reports and Printers
Date: Tuesday, May 22, 2012 7:28:03 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

I am using SET REPORTBEHAVIOR 90 when the reports are generated through FoxyPreviewer. SET REPORTBEHAVIOR 80 causes the reports to be handled via the VFP Preview. I have a check box on my form to tell the app which preview to use and SET REPORTBEHAVIOR controls switching between them.

Garth Groft

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