Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 29th June 2017, 13:05
amator's Avatar
amator amator is offline
Junior Member
 
Join Date: Aug 2016
Posts: 26
amator is on a distinguished road
Baan: Baan 4 - DB: SQl Server 2012 - OS: Windows 8
Post List Window Type Session (Multi Table)
Baan: Other/Unknown
C/S: None/Unknown

Hi Guys,

I'm making a List Window Type Session but I can't display the other table fields except the main table that I declared. Is it possible to create a List Window type that consist of fields that came from different tables?

My main goal here is to export the data to an EXCEL file. I can't do this in report because as you know when you create a report it goes with pages which is not I need, I need a report that is already ready for an excel format.

Asking for your support,
Amator

Last edited by amator : 29th June 2017 at 13:06. Reason: Grammar correction
Reply With Quote
  #2  
Old 29th June 2017, 14:30
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,322
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
What you can do is - add form fields, and write your own logic to fill those fields in before.field: section of those fields.

e.g. If you have tdsls401.orno, tdsls401.pono, tdsls401.sqnb and you need to add Shipment#, you can add a form field called shpm.f and write the below logic -
Code:
field.shpm.f:
before.field:
         shpm.f = ""
         select whinh431.shpm.f
         from whinh431
         where whinh431._index5 = {whinh.oorg.sales,:tdsls401.orno,:tdsls401.pono,:tdsls401.sqnb}
         selectdo
         endselect
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Sponsored Links
  #3  
Old 30th June 2017, 10:19
amator's Avatar
amator amator is offline
Junior Member
 
Join Date: Aug 2016
Posts: 26
amator is on a distinguished road
Baan: Baan 4 - DB: SQl Server 2012 - OS: Windows 8
Lightbulb It works perfectly!

Quote:
Originally Posted by bhushanchanda View Post
What you can do is - add form fields, and write your own logic to fill those fields in before.field: section of those fields.

e.g. If you have tdsls401.orno, tdsls401.pono, tdsls401.sqnb and you need to add Shipment#, you can add a form field called shpm.f and write the below logic -
Code:
field.shpm.f:
before.field:
         shpm.f = ""
         select whinh431.shpm.f
         from whinh431
         where whinh431._index5 = {whinh.oorg.sales,:tdsls401.orno,:tdsls401.pono,:tdsls401.sqnb}
         selectdo
         endselect
Hi bhushanchanda,

Thanks for the unwavering support. This helps me alot. I've learned something new.

Thank you so much,
Amator
Reply With Quote
  #4  
Old 30th June 2017, 15:30
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,322
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
Glad it helped!
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
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
Multi main table session creation mathew Tools Development 1 5th December 2013 13:41
Index availability on zoomed sessions chavez Tools Administration & Installation 3 22nd October 2013 21:47
Handling Unit functionality baazigar Distribution, Transportation & Warehousing 4 19th February 2012 16:54


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


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