Can not PRINT REPORT after viewing it

[bebbo]

If I view a report all information looks correct. However if I print the same report from the print button within the view mode only headings print. None of the fields print. This appears to be only on certain printers/computers. Any ideas?

 

[rgbean]

You don't indicate the version of VFP you are using, but you may want to check out <

http://support.microsoft.com/support/kb/articles/Q157/9/53.asp>

- FIX: Print Button in Preview Does Not Respect the FOR Clause.

Rick

 

[bebbo]

Thanks for the advice. My program does use the &quot;For&quot; statement. Unfortunately the link you adviced is unavaliable. I'm using Visual Foxpro V 6.00. Thanks

 

[rgbean]

Sorry, I forgot that you don't want to put <> around URL's here (just in the newsgroups) - try

http://support.microsoft.com/support/kb/articles/Q157/9/53.asp

, and while the articles only lists the problem &quot;officially&quot; for VFP 5.0, sometimes they still apply to the current versions.

Rick

 

[bebbo]

Thanks for you help. Although the &quot;FOR&quot; command by itself appears to of been fixed it does not like the following statement, among others. Thanks for directing me to the problem.

REPORT FORM PurHistA ;
FOR !EOF('CardT');
AND BETWEEN(CardT.DATE, FromDate, ToDate) ;
AND CARDT.TYPE != 1 AND Postr.status = 0 ;
PREVIEW

 

[rgbean]

First, assuming the current selected table/cursor is &quot;CARDT&quot;, then the condition !EOF('CardT') isn't needed - it's implied.

In general, I've found that it's ultimately easier to pre-process the data and let the report work off a virtual &quot;flat file&quot;. In this case consider an SQL Select (or a Local View if you're dealling with millions of records) of the appropriate records and feed the resultant record set to the report.

A concrete example could be given if more information on what code directly proceeds the REPORT statement. Like what table is selected, how and what relationship is established between CarsT and Postr and if any other tables (fields) and relationships are involved in the data on the report form.

Rick