Hi All,
I have a problem where i would would like to add together a list of records based on another statement. The table looks similar to this.
Salesnum | SText
________________________________________
1 | Invoice for
1 | £100 for work 1
1 | carried out
1 | blah blah blah
2 | some more text
2 | invoice more
2 | money.
Basically i have a table with salesorder number in the first column and text relating to that salesorder in multiple columns. My problem is that crystal reports displays it as multiple records. I would like to concatenate the text for each salesorder into one string?
How could i do this.
I have tried syntax such as
{tblText.SText} + " " + next{tblText.SText}
the next only gets the next record and not all which relate to salesorder 1. I have tried a series of loop statements of which i didnt get anywhere.
Please help!
I have a problem where i would would like to add together a list of records based on another statement. The table looks similar to this.
Salesnum | SText
________________________________________
1 | Invoice for
1 | £100 for work 1
1 | carried out
1 | blah blah blah
2 | some more text
2 | invoice more
2 | money.
Basically i have a table with salesorder number in the first column and text relating to that salesorder in multiple columns. My problem is that crystal reports displays it as multiple records. I would like to concatenate the text for each salesorder into one string?
How could i do this.
I have tried syntax such as
{tblText.SText} + " " + next{tblText.SText}
the next only gets the next record and not all which relate to salesorder 1. I have tried a series of loop statements of which i didnt get anywhere.
Please help!