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 20th November 2017, 09:46
sobiratul sobiratul is offline
Junior Member
 
Join Date: Jun 2014
Posts: 10
sobiratul is on a distinguished road
Baan: LN FP 7 - DB: SQL - OS: Windows
Report Customization : Add Data from Different Table
Baan: ERP LN 6.1 FP7 (Infor ERP 10.1)
C/S: None/Unknown

Hi,

I want to customize report from session tfgld1101m100 and table tfgld101.
I also required data from session tfcmg2100s000 and the table tfcmg204.

How to get / retrieve the data?

Herewith I attached the session.

Thanks,
Sobiratul
Attached Files
File Type: pdf Finance Report.pdf (287.6 KB, 16 views)
Reply With Quote
  #2  
Old 21st November 2017, 08:11
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,320
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 join tfgld101 and tfcmg204 based on the Year, Batch and Transaction Type to get the report output.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 22nd November 2017, 02:24
sobiratul sobiratul is offline
Junior Member
 
Join Date: Jun 2014
Posts: 10
sobiratul is on a distinguished road
Baan: LN FP 7 - DB: SQL - OS: Windows
Can you give example of code / coding how to join these tables?

Thanks,
sobiratul
Reply With Quote
  #4  
Old 22nd November 2017, 11:23
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,320
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
Here you go -

Code:
select tfcmg204.*,tfgld101
from tfcmg204,tfgld101
where tfcmg204._index1 refers to tfgld101
selectdo
           |*Write your print statements here...
endselect
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
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 print condition Elrodyn Tools Development 3 18th March 2009 11:13
data stored on a table, to do a report mig28mx Tools Development 11 29th January 2007 18:39
CODE: Table Loader ~Vamsi Code & Utilities 3 26th February 2003 14:05
tfacp9450m000 FIBU Brush Up Kai's Forum Users Deutsches Forum 1 16th November 1999 01:00


All times are GMT +2. The time now is 14:50.


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