Hello everyone,

I have a report where I have a text field (TXT1) and I want to have a second field that has several occurrances and put it in a text field(TXT2). So, the report print as a regular text field without reprinting the entire record. TXT2 below will be my multi-occ string that I want to move to a text type field. TXT1 is my regular text field. AAAAA and XXXX fields are other fields.

AAAA XXXXXXX TXT1 TXT2
TXT1 TXT2
TXT1 TXT2
TXT1
Any idea is appreciated.

Thanks in advance,

This code combines two fields tcmcs041.dsca and tcmcs080.dsca with two ".." between the field. This also strips spaces from the fields and puts the resuts in AAAA field. Hopes this helps
AAAA = strip$(tcmcs041.dsca) & ".." & strip$(tcmcs080.dsca),

strip$ This returns a specified string without trailing spaces

Sorry If I did not explain well myself... I want to have a multiple rows for TXT2 made out of a table records without duplicating the AAAAA XXXXX record.

It is fine, I think I'll find another solution.

Thanks,

Well - I don't know if this would work, but couldn't just supress the printing of AAAAA XXXXX in the report itself? I think I see what you are asking for, but can't think of a good way to get there.

Thanks Mark, No it doesn't work with the suppressing. The thing is the text field in reports, do that(suppress other fileds and prints the text in multiple rows).

Doesn't matter, I used stacks and things are now fine.

Thanks again.