Page 1 of 1
Concatenating strings
Posted: Thu Sep 19, 2002 9:31 am
by ColinDow
I have a recordset which takes the form____Product__XX__XYZ__YZA__BBB__AAA__ABC__etc____I^s like to produce a report which groups to a particular criteria (say product category - not shown) so that on the footer I get a concatenated string such as____1)XX,XYZ__2)YZA,BBB,AAA__3)ABC etc.____I dont know how many products will exist when the report runs.
=> RE: Concatenating strings
Posted: Thu Sep 19, 2002 10:58 am
by rickwjohnson
I asked this same question several years ago when R&R was with WallData. The tech then sent me R&R Tech Bulletin #6 - Printing Related Records on one line in R&R for Windows. Perhaps Kathleen has access to it and can send it to you. If not, email me at rickwjohnson@hotmail.com and I will send you a copy. (I do not have a fax, so snail mail is the delivery method.) It is 4 pages long with an example. ____Rick Johnson
==> RE: Concatenating strings
Posted: Thu Sep 19, 2002 11:42 am
by ColinDow
Thank you Rick.__Kathleen I had a quick look at the tech bulletins but didnt see anything that looked like the document in question.____Do you know if it is still available anywhere.
===> RE: Concatenating strings
Posted: Thu Sep 19, 2002 2:43 pm
by kfleming
It is http://www.livewarepub.com/ftp/TechDocs/Printing_Related_Records.pdf____Kathleen__R&R Support
====> RE: Concatenating strings
Posted: Fri Sep 20, 2002 5:37 am
by ColinDow
many thanks