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
18%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 34

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 4th December 2018, 09:52
itpanarub's Avatar
itpanarub itpanarub is offline
Junior Member
 
Join Date: Oct 2018
Posts: 8
itpanarub is on a distinguished road
Baan: Infor LN 10.5 - DB: Sql Server 2016 - OS: Windows
Unhappy How to display text to report
Baan: ERP LN 6.1 FP9 (Infor ERP 10.3)
C/S: None/Unknown

Hi all

I need to display text from Purchase Line to the report Purchase Order Related to Invoices (tfacp143011000).

i have follow from sales report like this bellow, but not display the text.


i have add the text field tdpur401.txta in the Input Field

Code:
detail.1:
before.layout:

select tccom100.nama:namebp
from tccom100
where tccom100.bpid ={:tfacp240.otbp}
selectdo
endselect

| Display text
after.layout:
field.tdpur401.txta:
please anyone can help me.
__________________
Regards
Susilo
Reply With Quote
Sponsored Links
  #2  
Old 4th December 2018, 15:09
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,146
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Not sure I get what you are showing. Is tdpur401.txta retrieved in the session code and then passed to the report? If so then you just add it to the reports input field, and then go add it to the layout you want it on. No report script needed.

Now if the tdpur401.txta is not part of the source session - then you can go into the report and add a query to retrieve it. Add the query in the before layout of the section where you want the text to print. Do not add tdpur401.txta to the reports input fields - not needed. So Just add the table in the declarations and do the query in the report script. Then just add the report field tdpur401.txta into the layout.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
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
Programming Question mr_suleyman Tools Development 37 11th November 2016 09:14
How to display item text in report script shahromi Tools Development 5 16th February 2016 07:03
Display Text to multiple lines in report Grace Cheong Tools Development 2 8th July 2011 12:19
Appending extra text at start of each text line on report aardvark Tools Development 2 23rd June 2004 16:01


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


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