Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
17%
500 - 800 GB
6%
800 - 1200 GB
6%
1200 - 1500 GB
17%
1500 - 2000 GB
17%
> 2000 GB
22%
Total votes: 18

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 10th November 2014, 23:02
ben.kansas's Avatar
ben.kansas ben.kansas is offline
Member
 
Join Date: Aug 2007
Posts: 68
ben.kansas is on a distinguished road
Baan: LN, Baan IV - DB: SQL Server - OS: Windows 7
Peek at next record in Report Seq File
Baan: Baan IVc4
C/S: Both

Hi All,

I want to supress a layout on a report until the next record in the seq indicates that the item group is different from the current item group.

Is there a way to peek at the next record in the Report Seq file from the Report Script (program script is unavailable)? Preferably without advancing the position in the file.

Thanks,
Ben
Reply With Quote
  #2  
Old 11th November 2014, 10:12
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,355
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi,

You can create a before.field layout for that field which. So, it will print only when changed.

Also, if you want other way, you can use combination of on.change.check(field_name) and if changed(field_name). Now, if the field is changed, suppress the layout using lattr.print = false.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 11th November 2014, 12:04
vamsi_gujjula's Avatar
vamsi_gujjula vamsi_gujjula is offline
Senior Member
 
Join Date: Nov 2011
Location: hyderabad ; india
Posts: 240
vamsi_gujjula is on a distinguished road
Baan: ERPLN fp3 and 10.4 - DB: oracle - OS: Aix , Redhat linux 6
can be done using report script as well as the way bhushan suggested ..

checking Nth record with N-1th will also give you the same.... ie print Nth record if N-1th record group is diff. else skip ..
__________________
Regards,
Vamsi
Reply With Quote
  #4  
Old 12th November 2014, 00:14
ben.kansas's Avatar
ben.kansas ben.kansas is offline
Member
 
Join Date: Aug 2007
Posts: 68
ben.kansas is on a distinguished road
Baan: LN, Baan IV - DB: SQL Server - OS: Windows 7
Thanks for your help, guys. You got me going in the right direction.
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
report file in $BSE/application does not exist simona Tools Development 7 12th September 2013 16:38
Question: when printing a report to notepad, how to keep the file name baanln Tools Administration & Installation 3 21st March 2013 22:14
bshell received SIGTERM manojsharma Tools Development 11 5th June 2008 09:22
Preserve position of record pointer in report script Neal Matthews Tools Development 19 17th January 2007 15:54
Temporary device file created in BaaN report printing kaukul Tools Development 3 9th January 2006 04:03


All times are GMT +2. The time now is 12:46.


©2001-2018 - Baanboard.com - Baanforums.com