Now that I read what I typed I can see that I am not doing a very good job of explaining, my apologies.
Actually I have 2 reports where as I said earlier the static contents are totally different, the variable data also is in a different position on both reports.
So effectively what I was trying to say is that in table 1 lets say records 1 to 10 are unique they use report 1 then records 11 to 12 are common in both tables then print these 2 records using report 2 & record 13 onwards use report 1.
I hope it makes sense what I am trying to say.
regards
Murali
> > Hi Jun,
> > Actually I have nothing to do with grouping.
> > The static contents of the letter differ that's all the variable data remains the same only position changes.
> > Now what I do is print the data from table one separately then table 2 separately then physically replace the paper from table 1 with paper from table 2.
> >
> > regards
> > murali
>
> Then it appears all you need to do is combine the records to a single cursor. Join the two together then perform a distinct later to remove duplicates. Or am I reading it wrong again?
>
> P.S.
>
> You can add a logical or integer field to mark the table where the record comes from when you do the join. And use that extra field as a way to know when to switch position of objects in your report.
>
> ssClasses library:
https://vfpx.codeplex.com/releases/view/99045> My Blog:
http://sandstorm36.blogspot.com