Try to use SQL or Create a Temporary Cursor and populate it with all the data you need making any
operation you want
This is an example of how to create a cursor and hot to populate with data with two tables, you can see the help for data types
and other commands
Use Table1 In 0
Use Table2 In 0
CREATE CURSOR MyCursor(FIELD1 C(10), FIELD2 N(10), FIELD3 N(13,2))

Select Table1
Scan
Select Table2
** Operations...
** Put here your code to populate cursor...
** More code has needed
Select Table1
EndScan

Or try with SQL, this is an example not complex, but you can create more complex query

Select Table1.Field1, Table1.Field2, (Table2.Field2*nValue) AS Fieldn From Table1, Table2 Into Cursor qCursor Where Table2.Field1 = Table1.Field1 Order By Table1.Field1

Select qCursor
Report Form Myform to Printer Prompt Noconsole


And in your Report, not need to use the dataenvironment