>yes, create a cursor to be filled with a select statement later. You see, I'm having trouble figuring out how to reference a field in that cursor from a field in a report.

Just have your SELECT statement create a cursor:

SELECT * FROM Mytable INTO CURSOR MyCursor

REPORT FORM MyReport

and make sure your report is not set to use pricate datasessions.