>I can't figure out what I'm doing wrong. I have a typical invoice form with child recs in grid that is base on a view. The form works great. I also have a button on the form to print the invoice the user is currently viewing. I've create the report but for some strange reason, I can't get the report to print more than one child rec on the report. I've used SQL cursors for child recs on other similar forms and have had no problems creating reports from them. For your info, I've set the Datasession to Default, no tables are set to open in the DE, and yes, I have the proper setting in the Data grouping. Some more info, if I put this code:
>
>SELECT lvitems
>BROWSE
>
>in the DE's BeforeOpenTable event, I could see all the child recs.
>
>Any life-saving ideas???
>TIA
>John.
Hi,
You select parent workarea with set skip off ? This would print only one child rec.
You can get all in many ways. Here are some :
- Set skip
- Use a view including the parent
- Use a temporary SQL cursor
- Use child related into parent in report DE and data grouping (reverse parent -> child)
Cetin