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: 83

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 22nd June 2004, 16:09
aardvark aardvark is offline
Junior Member
Join Date: Mar 2003
Location: UK
Posts: 11
aardvark is on a distinguished road
Baan: 5.0b -
Appending extra text at start of each text line on report

In Baan 5.0, we have developed a new Baan report. One of the report layouts contains a text field (field tdpur400.txta) that is an input field to the report.

We need to append certain characters to the start of each text line (for the purposes of our document presentation software), and this is achieved by the following code in the report script:


function validate.textline()
lattr.textexpand = TRUE
lattr.prline(6) = lattr.prline(1)
lattr.prline(1;5) = "htxt "

The result of this is that, for example, if the text field tdpur400.txta contains the following:

"Text line 1
Text line 2
Text line 3"

then this field is output on the report as:

htxt Text line 1
htxt Text line 2
htxt Text line 3

This does exactly what we need. However, we need to achieve the same result with another text field (tdsls400.txtb) that is NOT an input field for the report but is instead retrieved from within the report script. (Unfortunately it is not an option to retrieve the field in the program script and make it an input field to the report).

I would be very grateful for any code that we can put in the report script that allows us to 'format' the text field so we can add in the required characters at the start of each line for the report.

Reply With Quote
Old 23rd June 2004, 14:03
JaapJD's Avatar
JaapJD JaapJD is offline
Join Date: Sep 2002
Location: Netherlands
Posts: 868
JaapJD will become famous soon enoughJaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
Never tried it myself, but it should work:

detail.20:                |* Layout to print tdsls400.txtb
           save.txta = tdsls400.txta
           tdsls400.txta = tdsls400.txtb
           tdsls400.txta = save.txta
In the detail layout you define the tdsls400.txta field.
Reply With Quote
Old 23rd June 2004, 16:01
aardvark aardvark is offline
Junior Member
Join Date: Mar 2003
Location: UK
Posts: 11
aardvark is on a distinguished road
Baan: 5.0b -
Works fine - thanks!

Your suggestion did exactly what I needed - excellent. Thanks very much for your help.
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
Appending text to a report field pjohns Tools Development 5 22nd July 2003 16:59
Print text line by line dansimmo Tools Development 11 18th October 2002 11:43
CODE: VB Calling a DLL gfasbender Code & Utilities 0 13th March 2002 17:42

All times are GMT +2. The time now is 17:24.

©2001-2018 - -