Report and SubReport--printing problem--

[jkejke]

Have a report that is used as a letter--it pulls up Name, Address, city, St, Zip and the basic letter--subreport pulls up listing of certain items from another table--both of these work fine--to a certain point---if have more than five (5) of items starts to put signature portion of letter on another page--users want all of signature block on same page--suggested using Word and recreating but no go--

Thanks

 

[tempclerk]

Will the whole letter fit on one page? If you are seeing white space between the details and the signature, you probably need to set some Can Shrink properties. (The Detail Section, Subreport, etc.)

 

[jkejke]

If less than 6 rows of data will fit on one page--over six goes to two pages--can be from one to 20 rows of information on subreport- have done can shrink, etc

 

[jkejke]

forgot to mention that can not move further up on page because using window envelopes and address is in correct place--is legal type document so nothing can be changed, or shortened--

Thanks

 

[tempclerk]

Is your signature portion in a page footer? Probably should be; that will always print in the same place. And if necessary, I think I've heard that you can suppress printing the footer on some pages.

Or maybe as a report footer with Keep Together property set? Guess I'm not totally clear on what you're trying to do.