Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report not printing correct record
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00243306
Message ID:
00243585
Views:
20
No need to RECORD TOP

Just do the select then

SELECT * ;
FROM fullpric;
WHERE catno = thisform.catno1.Value ;
INTO CURSOR mycursor

REPORT FORM /reports/gpcalc.frx NOCONSOLE TO PRINTER PROMPT

Ensure that you have no tables in the report DE and that no textbox in the report references an alias (unless you will always put the result in an alias like mycursor).

The record pointer for fullpric shouldn't have moved.

>Thanks Evan, your suggestion about the cursor *almost* works. I use the following code to get the report to work properly:
>
>SELECT * ;
> FROM fullpric;
> WHERE catno = thisform.catno1.Value ;
> INTO CURSOR mycursor
>
>REPORT FORM /reports/gpcalc.frx RECORD TOP TO PRINTER
>
>I used RECORD TOP in the REPORT command because the top record printed multiple times. I read where others on here had the same problem (bug?) with cursors/reports.
>
>The problem now is that when I move the pointer and try to print a second record the report paints itself onto my form! The second report will print properly, but I still get the report outputting onto my form as well. Any ideas?
>
>Also, after my report prints the record that my form is displaying the pointer will revert back to the top of the table so I have to move back to where I want it to be with my STEP button. This is a hassle when we need to print several records that are in sequence. Any idea on what could be causing this?
>
>Thanks for any help.
>Greg Matthews
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform