If I'm understanding the question correctly. I think you just need to create a view. The way I would do it is start a new query. In the query designer. Add all your tables and create a query that contains your desired resultant data set.

Then view the sql code, copy it and paste it into your application. Select that query after it is built and run your report from that.

A little trick that helps some people is to:
select into table mydata.dbf

call the table the same thing you will be calling your cursor. Add the table to your reports data environment. THen build your report with that table. Then remove the table form the report, we were just using it to enable drag and drop of controls. and change your select back.

select into cursor mydata.dbf

You could also do it the old fashoined way and just create a cursor, populate it porgramatically and run the report from that.

Hope this helps