Signature at bottom of page

[Nro]

Hello

I have one report to with the salesman signature printed at the end of the document.

I want to print the signature at the bottom of the document. I’d tried to put on the summary band, but it’s not printing at the bottom.

I’m using VFP 9 sp2

Thanks in advance.
Nro

 

[Mike Gagnon]

Try putting it in the report footer.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)

 

[Nro]

Hello Mike
Nope. It has to be printed only once, at the end of the report, even if I have 3 pages.

I put the signature on the print footer, then I tried to put a “Print when”, “NOT EOF()” and suppress blank lines on the blob field, but nothing.

I also tried to add a field in the printed file, go at the bottom, replace the field with 1 and put a “print when”.

SELECT tblDetail
GOTO BOTTOM
IF NOT EOF() THEN 
 REPLACE flEof WITH 1
ENDIF							&& NOT EOF()
REPORT FORM report\C_QUOT06f PREVIEW

The signature is printed at the bottom of the last page, but the footer band on the page 1 and 2 is not resized, so I have a blank space on these two pages.

Thanks

Nro

 

[Dan Freeman]

No matter where you put it, use the right PRINT WHEN expression:

_PAGENO = _PAGETOTAL

 

[Olaf Doschke]

If you want to print at the end, the condition wouldn't be NOT EOF(), but EOF(), wouldn't it? Too much negations?

Even if you'd use EOF(), you'll never get there, because the last record is before EOF() and so this will always be .F. for any detail line. But of course _PAGENO=PAGETOTAL is a really good expression for your signature report control.

And put it in the footer, because the footer always comes at the footer even after the summary band, the summary band is for a summary directly after the main detail, secondary detail bands and any group footer, but it's not the page footer. Ddon't be fooled about it's bottom position in the report designer, that's just because it's an optional band and came into VFP with VFP9 or 8.

Bye, Olaf.

 

[Olaf Doschke]

>but the footer band on the page 1 and 2 is not resized, so I have a blank space on these two pages.
Try the "remove line if blank" option for that problem.

Bye, Olaf.

 

[Nro]

Ok, the “Print when _PAGENO = _PAGETOTAL” is working.

I put the blob in the page footer, and “Supress blank line” is checked. But again, the report footer refuses to shrink for the page 1 and 2.

I look on other forum, and some post said that the footer is one of the bands that does no resize.

I’m sorry for my ignorance with VFP reporting, I’m more familiar with Crystal.

Thanks again.

Nro

 

[Olaf Doschke]

Well, FRX reports are also not my main area.

How about keeping the report control for the signature blob small and setting it's stretch with overflow? Perhaps that would make the general size small and only make the last footer larger.

What I just tested is a single line height footer with a report control printing the expression [replicate("a", rand()*1000)] And setting that control to stretch with overflow.

That gives a variable height page footer, so defining your signature image as stretch with overflow should also help.

Bye, Olaf.

 

[Nro]

Is it possible to resize the footer programmatically?

NRo

 

[Olaf Doschke]

Yes, because FRX simply is a DBF with different file extesion.
But no, because you can not change the size on the fly while the report runs, per page.
What could be a solution is the reportlistener, but I can't say I have done much with it.

Bye, Olaf.

 

[JRB-Bldr]

I am not 100% clear on where you DO want the signature to appear and where you DO NOT want it to appear.
* In Page Footer on last page ONLY?
* On a Detail line following last 'real' data line?
* Or where

And I am not 100% clear on what the 'signature' is:
* an Image file displayed in a Report Form Object?
* a Text line?
* or what

But I can't help but think that maybe the answer is by using the somewhat Rube-Goldberg method that I have used many times for complex report layouts of over-laying the Detail Band Objects from 2 separate Report Forms (each with separate Print When expressions) into a single comprehensive Report Form.

Maybe with more clarity I could either see that it would not work, or that it might.

Good Luck,
JRB-Bldr

 

[JRB-Bldr]

Alternatively, might consider using 2 separate Report Form's
* One with a minumum Footer for all non-last page
* One with a designated Footer for the last page

By pre-processing the data such that you could determine which records needed to go to Report Form 1 and which needed to go to Report Form 2 you could sequentially print what you need.

Good Luck,
JRB-Bldr

 

[Nro]

Hello. I’m sorry if I wasn’t clear enough. English is not my primary language.

All I want to do is to print a Bitmap (salesman signature) at the end of a document. The document sometimes have one page, sometimes it has 3 or 4 pages. The Bitmap has to be printed only once, at the bottom of the last page.

I can’t use the report summary band. It will be printed on the last page, but not at the bottom.

I can put my bitmap on the report footer and issue a “Print when” “_PAGENO = _PAGETOTAL”. The bitmap will be printed on the last page, and at the bottom of the page. Perfect if I only have one page, but if I have more than one page, the first pages will have a blank space where the bitmap is supposed to be printed.

In Crystal Report, I can have one summary band (Report footer) and a property called “Print at bottom of Page”. This is what I want to achieve in VFP.

I hope is a little clearer.

Thanks again

Nro

 

[JRB-Bldr]

sometimes have one page, sometimes it has 3 or 4 pages

But as long as you know ahead of time how many records will fit onto each page, you can then separate out all of the records for the Not-Last-Page from those which need to go onto the Last-Page

If the total number of records will only require 1 page then they are Last-Page records and will go to VFP Report Form 'LastPage" which has your desired Footer.

If the total number of records will require more than 1 page, then you run VFP Report Form "NotLastPage" which has No Footer for the Not-Last-Page records.
And then immediately run the remaining Last-Page records to VFP Report Form 'LastPage" which has your desired Footer.

Note - this would not be an Ideal solution, but sometimes we have to invent a 'creative' approach to get the job done.

Good Luck,
JRB-Bldr

 

[TamarGranor]

Have you looked in "The Visual FoxPro Report Writer: Pushing it to the Limit and Beyond" (

http://www.hentzenwerke.com/catalog/vfprw.htm)

for a solution? Probably worth checking in the update (

http://www.hentzenwerke.com/catalog/vfprwext.htm)

as well.

If there's a way to what you want, Cathy's the one who'll know how.

Tamar