Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VFP Report Generator

Status
Not open for further replies.

Persmd

Programmer
May 21, 2003
38
US
I am converting an existing FoxPro 2.6 application to VFP 7.0. It has a number of native foxpro reports, which I have also converted. Some of these reports have 25 user selectable criteria such as SSN, or start and end dates for certain events. Each of the criterion appear as an individual line in the report's page header. The criteria fields in the report use the "Print When" option, and the "Remove line if blank" check box is checked.

It is unlikely that the user would select more than just a few of the criteria. In the FoxPro 2.6 application this worked fine, and the page header "shrunk" to only a few lines whe the report was printed or "viewed". Even though the converted (to 6.0 format) report has all the appropriate options selected, an error occurs when an attempt is made to view or print the report. The error (1298) is "Detail band is too large to fit on page."

If anyone has encountered (and solved) a similar problem, or has any ideas, your input would be greatly appreciated.

Thank you.
 
The print driver/setup probably has used a smaller page size than what your report was using. Try resizing your text boxes, and maybe use a smaller font until you get them to fit, then you should be able to open it up in VFP and adjust it.


Dave S.
[cheers]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top