>How would one go about telling the report designer that the source of the data to be used in the report is a temporary cursor from an SQL SELECT?

It's been at least a decade since I last did that...

First, don't save the dataenvironment with the report, and make sure the current alias is the one which has the fields for the report when you run it.

Another way is to not have the report's table open, but instead select a cursor with the alias it expects.