Concatenation
radbase
Central Texas, USofA
I have a situation where I want to take 3 fields and concatenate them on a report.
From one dataset I have a field (string) called name, and from a related second dataset I have two fields (numbers) called chapter and verse. I want the report to print a concatenated string of the 3 fields together; concatenated.
Example output would be Ester 8:9 (the longest verse in the Holy Bible).
I know this must be simple, but it's beatin' me up big time!!!
HELP!!!![>](style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" />)
From one dataset I have a field (string) called name, and from a related second dataset I have two fields (numbers) called chapter and verse. I want the report to print a concatenated string of the 3 fields together; concatenated.
Example output would be Ester 8:9 (the longest verse in the Holy Bible).
I know this must be simple, but it's beatin' me up big time!!!
HELP!!!
Comments
The actual embedded function is as follows:
[<frxDBDataset2."name"> + ' ' + IntToStr(<frxDBDataset1."chapter">) + ':' + IntToStr(<frxDBDataset1."verse">)]
Hopefully someone will get something out of this as it's really a common need in reporting.
(See the attached image file. The verse is the string I built from the above line.)