Concatenating values

[cricketer]

I am having trouble concatenating records.&nbsp;&nbsp;Imagine i am traversing down a table with 3 records, client1, client2 and client3.&nbsp;&nbsp;I would like to create a variable that stores &quot;client1client2client3&quot; as it's value<br><br>I am sure it's simple, however I'm going round in circles.<br> <p>John Beman<br><a href=mailto:johnbeman@ais-lims.com>johnbeman@ais-lims.com</a><br><a href=

http://www.ais-lims.com>www.ais-lims.com</a><br>

 

[edmac2]

Make a formula field and use concatenate such as<br><br>{ITEM.DESCRIPTION} + {ITEM.ITEMNUM} + {MATUSETRANS.GLDEBITACCT}<br><br>

 

[MalcolmW]

When you are working with multiple records (rather than fields) that you want concatenated, then you have to use a variable to store the value.<br>WhilePrintingRecords ;<br>StringVar ClientList ;<br>ClientList := ClientList + {Client}<br> <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>

 

[cricketer]

Thanks Malcolm, I had already done this.&nbsp;&nbsp;I was just checking there wasn't an easier way, some report writers allow you to total string fields just like number fields, giving you access to grouping,sorting and resets.<br><br>John <p>John Beman<br><a href=mailto:johnbeman@ais-lims.com>johnbeman@ais-lims.com</a><br><a href=

http://www.ais-lims.com>www.ais-lims.com</a><br>

 

[MalcolmW]

You could do the concatenation in a stored proc, which would then be returned to CR in a single row, which would then give you access to the grouping etc <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>