Hi Sir/Madam:

How do we separate the lines/rows in a text. Like for example, we have a text group with 10 lines/rows and 30 columns. How can we select only the 1st line/row to be reflected in a report field? How can we select only the 2nd line/row to be reflected on another field?

When you select the text number, the whole text is printed in the report field. We just want to print the specific lines/row. We are using the text under session Maintain Lots. We have standardized our data encoding on a per line basis, such that the 1st line will bear the analysis data, the second line is for quarantine data, and so on and so forth for the other lines. We have customized a report to include printing of this text but we would like to separate the data per line on each report field.

Looking forward for your usual assistance.

Thanks!

Look at lattr.print global variable.


g.Luck !

Hi Mr. Suleyman,

Thanks for your suggestion. I have searched the 4GL Functions Manual Pages but cant find the syntax on lattr.print. Perhaps you can elaborate further. Thanks!

It is a predefined variable. Refer to the link - predefined variables in a report script (http://www.baanboard.com/programmers_manual_baanerp_help_report_scripts_predefined_variables)

hi Wana I think that you are very new one on board. I would you know that
best tool on board is searching tool. If you search whatever you want , you find almost something interresting.

Try it ! and Go on ...

Look at lattr.print global variable.


g.Luck !

Did I miss something? How is lattr.print going to help mana print the text one line at a time? Maybe I misssing something, becuase I would recommend using TEXT.TO.BUF. This puts the text into a two dimensional array that can then be printed one line at a time.

Hi Sir/Madam:

How do we separate the lines/rows in a text. Like for example, we have a text group with 10 lines/rows and 30 columns. How can we select only the 1st line/row to be reflected in a report field? How can we select only the 2nd line/row to be reflected on another field?

When you select the text number, the whole text is printed in the report field. We just want to print the specific lines/row. We are using the text under session Maintain Lots. We have standardized our data encoding on a per line basis, such that the 1st line will bear the analysis data, the second line is for quarantine data, and so on and so forth for the other lines. We have customized a report to include printing of this text but we would like to separate the data per line on each report field.

Looking forward for your usual assistance.

Thanks!

Hello,

read the text with "text.to.buf" functions and split the textlines to separate textline variables !

LIKE :

#include <bic_text>

function read.and.seperate.textlines()
{

string tbuf(80,40)
long t
string text1(30), text2(30), text3(30), .........

|reset variables

text1 = ""
text2 = ""
text3 = ""
...........


for t = 1 to
text.to.buf("tiitm001.txta", "languagecode", 1, tbuf)

text1 = strip$(tbuf(1,1))
text2 = strip$(tbuf(1,2))
..................
endfor
}


Regards

Dear Sir,

Thank you all for your accommodation. I'm still figuring things out based on your inputs. Im new in report writing and SQL, im just learning by myself and your response had been very valuable to me.

Thanks for reaching out.

:)