Can you move the record pointer in the 1 to 1 table prior to sending it to a report? ie:
select myDbf
go bottom
go top
report form ???




>>1) Do you have the right table selected in your data environment of the report?
>>I should probably be your 1 to 1 table. I believe its called initial or something.
>
>I have a view selected for my data environment that consists of
>all three tables. I use this same view for other reports with
>no problems. The only difference is that the records are all
>appended in this particular form. When I use the report in other
>instances, the records already exist. I got it to work this a.m.
>by issuing:
> Select * from .... INTO cursor temp_view
> (temp_view is the same name as the view used in my report's
> data environment)
> Select temp_view
> browse noedit timeout 1
> Report form pos .....
>
>It puts all the child records in the report this way. Since I
>need 2 copies, I report the REPORT command. The second copy always
>has all the child records. That is my problem. The first copy
>of report doesn't have all the child records while the second copy
>does have them. By doing the browse, it puts all the child records
>in the first copy also. Do you see my problem? Any suggestions
>how to work around the browse?
>
>
>
>>2) If size is not a issue, heck put in in one table and don't let it repeat the field! Then it will only print once!!!
>>
>>The first note above I've seen before and figured work-arounds.
>>The second is only good if you are dealing with a small quantity of records.
>>
>>Have you attempted to create a small 1 to 1 and 1 to many test? many times I get too lazy to do this only to find out I am doing something stupid!
>>
>>Maybe try the wizard to see what is going on. Do you understand groups? This can also be a area to look into.
>>
>>Good Luck...
>>
>>
>>
>>>I tried querying the one to one first and then the one to many,
>>>it didn't work either. The first copy of the report picked up
>>>only one child record. The second copy of the report picked up
>>>both of them. Any other ideas??? I'm really desperate. This
>>>is the only thing keeping me from releasing my new version of
>>>my application. Thanks!
>>>
>>>>I don't think I understand. I already have the one to one above
>>>>the details band and the one to many in the detail band. The
>>>>report is based on a view which is named the same as the cursor.
>>>>How do I query in a different cursor? Do I query the one to
>>>>one relationship to cursor A and then select cursor A? Then,
>>>>select * from A and the many child table into the cursor that
>>>>the report is based on?
>>>>
>>>>
>>>>>Susan,
>>>>>
>>>>>Put the one to one in a group above the details band. Don't query the one to many in the same cursor, put it into its separate cursor or in the data environment set the relationship (whatever works best). Put the one to many data in the detail band.
>>>>>
>>>>>Robert...
>>>>>
>>>>>>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