Report Printing Issues

[mritmad]

Hello

I have issues with various reports after I upgraded from VFP8 to VFP9.

Basically, I create a local cursor in my form and issue the following command to print the report.

SELECT cur_mycursor
GO TOP 
REPORT FORM myreport TO PRINTER PROMPT NOCONSOLE

In the report, the fields refer to the cursor by cur_mycursor.fieldname. some reports omit the cur_mycursor.

What happens is that when I run the report as above, it does not print correctly, mainly by only showing 2 details lines (both the same) when there are several pages of data.

However, if I run the preview and print from there, all is fine.

Some reports are OK, some not.

I have tried SET REPORTBEHAVIOR 80 but that didn't work.
I have tried the dataenvironment as private and default, but that didnt work.

Anyone any ideas? Driving me mad.

Thanks

 

[TamarGranor]

It sounds like you don't have the right workarea selected. Is there a grid on the form? If so, make sure it doesn't have focus when you run the report.

Tamar

 

[mritmad]

Thanks for the reply, got me thinking

I created a bind event for the _screen to refresh it when it gets focus from another application.

However, it caused the reports issue.

Needs more thought these new VFP9 functions