General information
Category:
Reports & Report designer
Title:
Problem with report printing
I have a report based on a view. The view is a one to one
relationship between 2 tables and a one to many with the
third. I have used this report in various spots in the
application with success, but I have added a new tab to
the pageframe. I append the new record to all three
tables and issue a tableupdate when the user hits save.
The records are saved correctly. Then, I issue:
SELECT * FROM master, parts, sro;
WHERE master.con_sro_no = m.print_pos AND;
parts.con_sro_no = master.con_sro_no;
AND sro.con_sro_no = parts.con_sro_no INTO CURSOR master_sro_view
SELECT master_sro_view
REPORT FORM pos NOCONSOLE TO PRINTER PROMPT
master table = parent to sro table (one to one)
sro table = parent to parts table (one to many)
If I have more than one record in the many child table,
it only prints one record. If I repeat the report command,
the second command prints correctly. I put a browse in
my code before I ran the first report and the first report
command printed correctly. I have tried changing it to
print "Report form pos for master.con_sro_no =
parts.con_sro_no. When I have used this report
before, none of the records where new ones, they were just
being modified.
Any ideas? Thanks in advance!
Susan
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