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
38%
Installation Wizard into new VRC
38%
Manual into existing VRC
5%
Manual into new VRC
19%
Total votes: 42

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 27th December 2017, 13:18
ren_bsi ren_bsi is offline
Junior Member
 
Join Date: Dec 2015
Posts: 9
ren_bsi is on a distinguished road
Baan: LN 10.3 - DB: SQL Server 2008 - OS: Win Server 2008 R2
Data Grouping
Baan: ERP LN 6.1 FP9 (Infor ERP 10.3)
C/S: Both

Dear Gurus,

I'm trying to do Data Grouping in a customized print session as follow :

Item General Table :

Item Material
---------------------
A VCN
B KNL
C VCN

Expected Data Grouping result :

Materials : VCN KNL

I do have the following script in the report script :

Code:
before.curr.shpm.10:
before.layout:
select whinh431.item
from whinh431
where whinh431.shpm = {:curr.shpm}
selectdo
      select tcibd001.dscd:b.dscd
      from tcibd001
      where tcibd001.item = {:whinh431.item}
      group by tcibd001.dscd
      selectdo
         desc.dscd = desc.dscd & trim$(b.dscd)
      endselect
endselect
but the Data Grouping is not working and the result is : VCN KNL VCN which is incorrect.
Kindly need your advice.
Thanks in advance.

Best regards,
Rendy
Reply With Quote
  #2  
Old 29th December 2017, 10:18
vahdani's Avatar
vahdani vahdani is offline
Guru
 
Join Date: Aug 2002
Location: Cologne, Germany
Posts: 430
vahdani is on a distinguished road
Baan: all - DB: all - OS: Unix / Win2K
Hallo Rendy,

you cannot use group by if your select brings only one result. Use the following select. It selects the material for all items in shipment and then groups all these materials:
Code:
before.curr.shpm.10:
before.layout:
	select	tcibd001.dscd:b.dscd
	from	whinh431,
		tcibd001
	where	whinh431.shpm = {:curr.shpm}
	and	tcibd001.item = whinh431.item
	group by tcibd001.dscd
	selectdo
		desc.dscd = desc.dscd & trim$(b.dscd)
	endselect
And Happy new year!
__________________
May the force be with you!
Reply With Quote
  #3  
Old 2nd January 2018, 06:25
ren_bsi ren_bsi is offline
Junior Member
 
Join Date: Dec 2015
Posts: 9
ren_bsi is on a distinguished road
Baan: LN 10.3 - DB: SQL Server 2008 - OS: Win Server 2008 R2
Dear Vahdani,

It works perfectly.
Thank you so much for your kind help

Best regards,
Rendy
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 update the data to another table when delete the one data tracylee Tools Development 6 28th August 2015 09:38
Application data dictionary vs. run-time data dictionary NPRao Tools Development 5 7th July 2009 08:16
Audit file structure baan_user Tools Development 8 4th May 2007 14:32
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38


All times are GMT +2. The time now is 18:42.


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