Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
36%
Installation Wizard into new VRC
36%
Manual into existing VRC
7%
Manual into new VRC
20%
Total votes: 44

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 24th November 2017, 14:17
pralash pralash is offline
Senior Member
 
Join Date: Feb 2017
Posts: 208
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
How to send the query result in the report by using before.field event
Baan: Other/Unknown
C/S: None/Unknown

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
Attached Images
File Type: png 1.PNG (13.7 KB, 14 views)
File Type: png 3.PNG (31.2 KB, 12 views)
Reply With Quote
  #2  
Old 28th November 2017, 18:13
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,058
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Did you add tctls903.user to the reports input field? That would be the first thing I looked at in 4c4.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 29th November 2017, 06:02
pralash pralash is offline
Senior Member
 
Join Date: Feb 2017
Posts: 208
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
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
Reply With Quote
  #4  
Old 29th November 2017, 06:04
pralash pralash is offline
Senior Member
 
Join Date: Feb 2017
Posts: 208
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
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
Attached Images
File Type: png Capture.PNG (18.3 KB, 5 views)
Reply With Quote
  #5  
Old 29th November 2017, 08:13
Juergen's Avatar
Juergen Juergen is offline
Guru
 
Join Date: Aug 2001
Location: Germany
Posts: 578
Juergen is on a distinguished road
Baan: IVc4, ERP LN - DB: Oracle - OS: Linux, Unix
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
Reply With Quote
  #6  
Old 13th December 2017, 07:39
pralash pralash is offline
Senior Member
 
Join Date: Feb 2017
Posts: 208
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Thanks so much for your information...
Regards,
Pralash
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to send the array values to the report pralash Tools Development 2 23rd November 2017 07:00
no result for "delivered, not yet invoiced" report anthony_wang Finance, Invoicing and Integration 8 7th November 2002 14:38
send report on several printers macahu Tools Development 7 10th July 2002 10:27


All times are GMT +2. The time now is 16:03.


©2001-2017 - Baanboard.com - Baanforums.com