Mon,

Just create a simple flat cursor, ie join the two tables in your code. Don't have a DE in the report, if all you have are fieldnames without an alias the report will use the current selected alias when it runs. WHen I'm first creating a report I temporarily stick in a MODI REPO right after the cursor is created so it available to layout the report.

>Before I generate my report, I do some queries using SQL SELECT, and I save the results into Cursors. How do I use these cursors in my report? I couldn't just "add" a cursor to the Data Environment of the report. I tried to go around this by Writing my queries to tables, adding those tables to the DE, and then rewriting code so the query results are going into CURSORS again. However, the added table in the DE must have an INDEX to be able to set a relation between it and the other report table, and I cann't have an index with a CURSOR. Does this mean I should use tables instead of CURSORS?