Typically in VFP reporting is done by using a SQL select to get your data all together into a reporting cursor and run the report with that cursor as the input.
SELECT text2 ;
FROM mms ;
into cursor reportresult ;
report form TheReport...
You can run the query and start up the report designer, when you do not add the alias because it makes your life easier down the line.