Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with VFP 5 reports.
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00325481
Message ID:
00325930
Views:
22
Hi Andrews,
When you send a filtered record set to a a report (Report Form MyReport for State = "CA") it will show correctly on the preview OR if you send it directly to the printer as you found out. However, if you Preview it and THEN print from the preview it will print ALL the records, ignoring the "for" clause.

The solution is to make a cursor with just the records you want and send that cursor to the report:
Select * from MyTable where State = "CA" into cursor RptCursor NOFILTER
select RptCursor
Report Form MyReport PREVIEW
Another possibility is to disable the ability to print from the report and ask the user if they wish to print after the preview closes. This is substantially more complicated in VFP5, involving changes in the FoxUser table.

HTH
Barbara

>I have a problem with the reports of VFP5.0.
>Those of printer works well, but those of screen in the first fact prints me a registration that swims that see, and it alter me the totals.
>Who does this have experienced, that be in disposition of giving me an explanation and at the same time the answer to the problem.?
>TIA
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform