Ellen,
>Thanks. It worked. I was hoping there was an easier way than creating the cursor each time I want to change the report.
During development, you can easily cut and paste your SQL SELECT command from your program to the command window, change it if needed, and run it there to get a cursor for interactive use during report design. If you will be making lots of report changes with the same cursor structure, you can run the SELECT command, then something like
COPY NEXT 100 TO somefile
to save a snapshot of the cursor. Then you can
USE somefile
anytime you want to tinker with the report. Since you are no longer adding the alias in front of the field expression, the filename does not matter, only the structure.
Also, another tip: If creating a new report based on a SQL SELECT, and using the Quick Report menu option, uncheck the "Add alias" and "Add table to data environment" options.