Hi,
I'm new for LN Programming... I have created a before.field layout as shown in the attachment(1.png)... And my programming script is as follows...

select distinct tctls903.user
from tctls903
where tctls903._index1
inrange {:logg.first} and {:logg.t.change}
selectdo
message(tctls903.user)
|Here I got the user name but it's not sending to the report
rprt_send()
endselect

My before.field layout is attached as shown(3.png)....

My report script is as follows...
before.check.1:
before.layout:

if tot.log.detail = tcyesno.yes then
lattr.print = true
else
lattr.print = false
endif

While execute the script, I can displayed the distinct users with in the given range, but I got the last user name in the report instead of getting all user names... So how can I get the all user names in the report....
Please let me know that how to fix this issue...
Thanks in advance,
Regards,
Pralash

Did you add tctls903.user to the reports input field? That would be the first thing I looked at in 4c4.

Hi mark_h,
Thanks so much for your reply...
As you suggested, I already add the tctls903.user as a report input filed. But I can get the last row only in the report. At the same time, I can get print all records those are not send to the report....
Can you please give my any ideas to fix this issue...
Regards,
Pralash

Hi mark_h,
Thanks so much for your reply...
Sorry... I have missed the attachment in my previous post...
Could you please find the attachment....
As you suggested, I already add the tctls903.user as a report input filed. But I can get the last row only in the report. At the same time, I can get print all records those are not send to the report....
Can you please give my any ideas to fix this issue...
Regards,
Pralash

Hi Pralash,

think the problem is layout before.check.1

The field tctls903.user is part of that layout, but the before field layout will only be printed when the value of the field check changes.
So if field check always has the same value the layout is only printed once.

Regards,
Juergen

Thanks so much for your information...
Regards,
Pralash