Hi Chris,
First of all, check
Forms with Grids and printing reports FAQ #15515
Also I would prepare a cursor with all needed information and print using this cursor rather than working with two related tables. It's well known, that multi-related reports behave unpredictably...
>I'm having a frustrating problem with one of my reports.
>
>It's an Orders-LineItems type report that never seems to print the LineItems correctly. Sometimes I get just one lineitem, sometimes it repeats several times, and every once in a while, it prints correctly. Once, I previewed the report, and everything was correct. When I printed that one, the results weren't the same as the preview.
>
>I would believe that something is changing the current alias, but I can't find *HOW*. I've semi-proven this by including ALIAS() in the page header and the detail band, and seen it both the same and different. I've tried selecting the alias before starting the print routine, and in the report's dataenvironment.
>
>Everything in the detail band is LineItems.somefield, while the header is orders.somefield.
>
>How can I figure out when/where/why the alias is changing, and if it's not too much trouble, MAKE IT STOP!?
>
>As if that wasn't bad enough, it seems like the problem is spreading to other previously correct reports...
If it's not broken, fix it until it is.
My Blog