You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

print multiple rows from a select statement

1 reply [Last post]
Guest's picture
Guest

How do I print multiple rows from a select statement in SQR.
If I call the print procedure right after the select statement, it over writes each row on top of each other, result is each row is printed on top of the other.
Please suggest me a way to print all the rows onto a pdf report.

thanks,

Guest's picture
Guest
Re: print multiple rows from a select statement

Please call the print procedure inside the select statement like below

SELECT
FIRST NAME
LAST NAME
Do print procedure (Call your print procedure)
FROM PS_NAMES

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
13 + 3 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.