General information
Category:
Reports & Report designer
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only