i am creating report from our customised table.

script query :- select .* from abc
selectdo
rprt_send()
endselect

in report it is printing only 1st line (1st order)

i want to print all the order line . what is the best solutions.

Hi,

Can you provide some more information, like how many times the control goes in selectdo and how many time function rprt_send is called. Only one record is printed then which record is getting printed, the first or the last?

Also can you cross check how many records are present in the table. Because as per the query you mentioned, there is no where condition, it means it will print all the records in the table.

In this case the best practice according to me would be inserting required table fields in detail layout and them printing the report.

Regards,
--Rahul

1. it is printing 1st line only (order no)
2. defined field wise , but same result
3. no conditions define ( where condition)
4. in table 15 records available
5. in detail layout defined required fileds only.

Post the actual code and maybe a screen shot of the layouts and the fields. Does the selectdo look 15 times? You can put it in debug and check that. Maybe even add a message to see which item(or key field) it is processing. If it is looping 15 times then the problem is in the report - check the output expression and make sure it is reading in all 15 records. You can put the report in debug mode and even go out and check the temp file.

checked through debug. it is looping 15 times , but only 1 st record printing.

what is the next steps?

checked through debug. it is looping 15 times , but only 1 st record printing.

what is the next steps?

Hello,
as Mark suggest post your code and reportlayout.

Sortfields at report ?
Before fields ?

aso.

Regards

header and detail only defined in report layout. no before /after field . no questions of sort .

simple drag and drop from the table field

Okay the report script is looping, now debug the report. It should read all the records and print them. Other than that without posting some screen shots of the report layouts and such there is not much more we can do.