Hi,
I am customizing a report, in which I have used a select query of particular fields. While trying to print the values, the last row is printed always. how I can print the rows line by line.Please help me in proceeding..

Thanks in advance,
Thamarai.

:rolleyes:

Plz check where u have used rprt_send() function............It appears as if u have used it either in selecteos section of query or after the query......

Use this function in selectdo section .

Hi,
Thanks for the reply. I have attached the code. Still the last row is printed. Advice if i am wrong anywhere..

function get.rfq.no()
{
select tdpur202.qono from tdpur202 where tdpur202.rqno=:tdpur200.rqno
selectdo
rprt_send()
endselect

}

detail.1:
before.layout:
lineno = lineno + 1
get.rfq.no()

Thanks,
Thamarai.

it appears that u are working on Report script ....................

U cann't use rprt_script() in report script.................

here u will have to use layout.again()

in the before.layout section use an array to have all the values from table to array and then in after.layout section checking the no of records in array and then use for loop for that many no of time to execute layout.again()
Initialize the variable required to be printed.

Hi,
what type of array should i have to declare and get the data. Will it be like a recordset.

Thanks in advance,
Thamarai

yes ...similar to data set...

and also use a variable to print data from array on to report

Hi,
Can you please give me an example.

Thanks,
Thamarai.