Setting a Report Parameter to value returned from SQL statement
Setting a Report Parameter to value returned from SQL statement
(OP)
I am running a SQL query
and I need to set the report parameter equal to the
value returned in the SQL query.
and I need to set the report parameter equal to the
value returned in the SQL query.
Thanks,
Leo
RE: Setting a Report Parameter to value returned from SQL statement
RE: Setting a Report Parameter to value returned from SQL statement
<your query>
;
TABLE FILE SQLOUT
PRINT *
ON TABLE SAVE AS HOLDPARM
END
-RUN
-READ HOLDPARM &MYPARM.A(length).
EX <fexname> <parameter>=&MYPARM