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

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 66

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 4th December 2018, 08: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


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

| Display text
please anyone can help me.
Reply With Quote
Old 4th December 2018, 14:09
mark_h's Avatar
mark_h mark_h is offline
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,250
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.

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
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
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
How to display item text in report script shahromi Tools Development 5 16th February 2016 06:03
Display Text to multiple lines in report Grace Cheong Tools Development 2 8th July 2011 11:19
Appending extra text at start of each text line on report aardvark Tools Development 2 23rd June 2004 15:01

All times are GMT +2. The time now is 15:44.

©2001-2018 - -