I am trying to generate a pivot table (Matrix) report where some of the fields are in the sub-form, and the other fields are in the parent form.  Although they are related, the problem is that the report builder shows me only the fields of the form that I choose to build the report on.  If I chose the parent form, then I don't see the fields in the sub-form and vice versus.

Is there any tricks to go around that.  The tedious way or alternative is to copy each of those elements on the parent form onto the sub-forms when data is entered, but that is a lot of duplications and which also defeats the purpose of the parent form to sub-form relationship.

Any feedback is greatly appreciated.

Thanks