I have a report designed with headings, etc. The report prints result of SQL SELECT statement, but the SELECT statement is dynamic: it changes according to what user sets.

Example:
SELECT last,first from myTable1 where last='CHAMP'

and another time it would be:
SELECT last,dob from myTable2 ORDER by last
etc.

I have it set right now where in the report designer, there is only 1 long row (as can fit in a page) as exp1. Then the program passes exp1 to the report, to have it printed. exp1=the SQL SELECT statement. The problem is, exp1 must be a long character string. I have to convert all the fields to a string which makes the SELECT statement too long & when it gets too long, I get an error message. For example:
exp1='SELECT last+space(4)+str(idnumber,5) FROM myTable'
This can be very long & complicated with ORDER BY & WHERE clause, etc.

How can I best print a dynamic SQL SELECT result into a report?