"cursor processing" inside actuate

[tekatoo]

I have a need to do "nested" fetching. Once I fetch a record from the first level, I need match any and all records from a second level. I then need to get the next record from the first level and recycle through the second level again (from begin to end)... so on and so on until I reach the end of records in first level.
My problem is I'm unable to "recycle" the second level where I reread the first record.... I need something like a getfirst method so I can do my nested looping.
In pl/sql, I would open the cursor, fetch the records, close the cursor, then reopen the cursor so I can starting fetching at the first record. I have no clue how to do this in actuate... any suggestions.
THANKS

 

[Kuppaa]

If you are using a memory buffer then look into SeekTo function

You can also acheive this by a nested report. See the examples provided