report header 1

[fluppeke]

Hi Guys,

Either or I am stupid or Either i can't find it anymore
Working with vfp7 sp1
I am looking in the reporting for the report header and footer.
I don't know how to find it anymore ore am I confusing with crystal reports
Any help to make a report footer would help

Filip Merlier

 

[bborissov]

They are called "Title band" and "Summary band"


Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[fluppeke]

Hello Borislav,

ok I Agree with this function.
But i becomes after the page header en page footer

Filip

 

[fluppeke]

Hello Borislav

What I mean is that the summery band is printer after the last record and not after the last page footer

wfg,
Filip

 

[bborissov]

Summary band is printer before pafe footer and Title is printed before Page header.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[fluppeke]

Hello Borislav,

Is there any possiblity to have a band printed after the last page footer ??

wfg,
Filip

 

[bborissov]

No. Last band printed is page footer.
BUT if you want you can make Summary ban to be printed on new page and in all of your controls printed in footer bad put in Print when Expression:

_pageno < _pagetotal

That way the last page will have only controls you add in Summary band and no page footer will be printed.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[bborissov]

OOOPS! I just remember you use VFP7. AFAIK there is no _pagetotal system variable in that version. You must run report twice:

lnTotalPages = 99
REPORT FORM .... TO FILE TestMe.TXT NOCONSOLE NODIALOG
ERASE TestMe.TXT
lnTotalPages = _pageno
REPORT FORM ....

and in print when put:

_pageno < lnTotalPages

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP