General information
Category:
Reports & Report designer
Title:
Printing dynamic SELECT statement result with report dsgr
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only