>Thanks for the quick reply Evan. If I do create the SQL cursors in the init event of the DE, how can I set the relations with the main report table? For example, if the main report table has a user ID, and the CURSOR has a user ID and name, how do I set the relationship between the two so that the report shows the user name along with his ID?
>

Your final cursor is "de-normalized" (so to speak). In your SQL statments you have associated the name with the id. Your report therefore uses only the data from one cursor, no joins are required.

Example:

select person.name, labtest.value;
from person, labtest;
where person.id = labtest.id;
into cursor pvalue

Does that make sense?