Specifying page Length

[gee001]

Hie all

I am using FPW26 i have a report form that falls out of alignment after the first page. how do i specify the page length ??

please help

 

[JRB-Bldr]

One way to ensure that the page was advanced on a specific number of records would be to add a new field to the report table. As part of your pre-report processing you would want to increment this field when the record count (or integer multiple of records) passed your pre-determined page requirements.

Then within the report add a Data Group and set it up so that a New Page was launched when the value changed.

If your "falling out of alignment" is because of something else, please give us more detail and we will be able to offer other suggestions.

Good Luck,
JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com

 

[rgbean]

The "page length" is based on your current Printer driver. This can be overridden by the printer information in your .FRX header record, unless you clear out the info in the TAG and TAG2 fields. Details on how to do this are in the FAQs on the VFP forum or in a couple different articles in the MS Knowledgebase.

Rick

 

[gee001]

I actually needed to print on preprinted stationery (sorry i never mentioned this). I am printing to an EPSON 5000+ printer. I changed the DIP switches setting on the printer for a 11 inch page length, this seems to be ignored as a 'falling out off allignment occurs on the next page.

Sorry if i wasn't any clearer earlier. Desperation can sometimes get to you.

I'll wait

 

[JRB-Bldr]

I am not specifically familiar with the Epson 5000 printers, but if you have been changing DIP switches check to see if you have a switch which controls "Print over perforation" (or something like that). Yes, with pre-cut sheets we do not often have "perfs", but we do have bottom margins which would be ignored if this switch is active (TRUE).

Getting formatted output laid out on paper is often a time-consuming job, but it will eventually pay off. Typically your report's page will have a header section and a detail section. By trial and error you can determine how many detail lines it will take to fill a page.

I would still recommend (like above) considering the use of a "Page Advance" variable to trigger the use of the next page. If the pages after your first page uses a different number of detail lines, this variable could handle it also if the pre-report calculations were appropriately correct.

Rick (rgbean) is also correct in that you may want to check your TAG & TAG2 Memo fields within the FRX table (record 1) to see if some other printer's definition was throwing your report off. If so, clear the Memo fields out.

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com

 

[gee001]

Hey JRB-Bldr

I will obvious tryout some of your suggestions. Tomorrow is a Holiday here in Zambia (Africa). So you will hear from me on thursday, i can't tryout your solutions now as me have to break off.

You will hear from me.

Thanx

 

[cricket]

Check if a TOF (top of form) command has been issued before page 1 starts. You can do this by pressing the form feed button on your printer. If you get the misalignment you report, then this could point to your problem.

 

[gee001]

Hie !

Back from Holiday,( I needed it )

I cleared the TAG and TAG2 fields in the FRX file and run the report.

It worked like a charm,

Thanx to all