Steven
1. You can't make the cursor visible in the reports data environment.

2. Once you create the cursor you can index it just like a table as long as the cursor is not buffered.

3. Once the index is in place you can set relation from another table. Saying that, I try not to use relations and have all the data for the report in the cursor. Sometimes this is not practical though.


>Hi all,
>
>Upto now I have been creating reports using actual tables in the dataenvironment. Recently, I was trying to create a report using a cursor created through SQL. I have 3 questions:
>
>1. How do I get this cursor visible in the dataenvironment?
>2. How do I create an index for the cursor ?
>3. Can I create a one-to-many relationship with a table like how I do with an actual table, using the above index as a reference?
>
>Thanks,
>
>Regards,
>
>Steve