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

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 49

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 17th January 2017, 06:24
shradha.d shradha.d is offline
Junior Member
Join Date: Jan 2017
Posts: 3
shradha.d is on a distinguished road
Baan: LNfp3 - DB: oracle - OS: Worktop
Print Delivery Notes- Report customization - Merge 2 item rows in report script
Baan: ERP LN 6.1 FP3
C/S: None/Unknown

Hi Pals,

Session: whinh4477m000
dll : inhdll4477

We have a customized Report where we are Printing Item Details in table format. Many records that are Printed are identical and only Shipped quantity is different.

Current Output:
No. Item Item Description Quantity
10 A abc 5
10 A abc 10
20 A abc 7

Required output
No. Item Item Description Quantity
10 A abc 15 <---- 1st 2 rows are merged
20 A abc 7

I cannot make changes in the Program Script or Dll. Need to make changes only in report script to attain this.

In Report Layout , each record is printed using the input variable and then 2nd record is printed using layout.again().

How to get all the records at once and manipulate the data to get the desired output.
Reply With Quote
Old 19th January 2017, 07:07
Ajesh's Avatar
Ajesh Ajesh is offline
Join Date: Feb 2009
Posts: 508
Ajesh is on a distinguished road
Baan: LN 10.4 - DB: Oracle - OS: HP-Unix
in detail layout you will have to dynamically assign the value of Position Number and Item to an array, and pre calculate the value of quantity before printing the layout.

And for every detail you will have to check if it exists in the dynamic array? If it exists then do not print it and if it does not exists then you have to pre calculate the quantity and print it.

Use lattr.print = false for not printing the records.
Reply With Quote
Sponsored Links

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
print 2nd report from 1st report script cmandal Tools Development 6 14th October 2012 23:56
Variable value different in pgm. script & report script ? PacSun Tools Development 5 28th June 2006 19:09
Name of Report in device script mostrightfuture Tools Development 1 16th July 2004 06:05
Surpress the print of a report from within the report script Neal Matthews Tools Development 9 27th May 2004 17:57

All times are GMT +2. The time now is 00:24.

©2001-2018 - -