I am new in crystal report. I have a dataset which like this:
FieldA
---
name1
name2
name3
Now, i want to join them together like this : "name1, name2, name3". I try to use the function join(list, delimiter) but fail. It seem that i should get all the data in place them in a array.
How can I do this? Thanks!!!!!check if this is possible
{database.name1}+{database.name2}+{database.name3}|||Thanks for your reply
However, in my case, all the data which is inside the same field.
For example:
Table1.field1
------
Record 1) A
Record 2) B
Record 3) C
I want to join them to "A, B, C" and display in the report
Anyone know how to do? Thanks!!!|||What groups these 3 records together, so that you know they are related? e.g. so that "A, B, C" comes out on a separate line to "D, E, F".
Group on this, and create 3 formulas:
@.init (in the suppressed group header)
whileprintingrecords;
stringvar group_list := "";
@.add (in the suppressed details)
whileprintingrecords;
stringvar group_list;
if group_list <> "" then group_list := group_list + ", ";
group_list := group_list + {table.field};
@.display (in the group footer)
whileprintingrecords;
stringvar group_list
No comments:
Post a Comment