Dear all,
Few months ago, I try to concatenate cells under a Group,
I succeed using the formula gave by Raghavendra
Initialize:
whileprintingrecords;
stringvar i:="";
Place the above formula in group header and suppress group header section.
evaluate:
whileprintingrecords;
stringvar i;
i:=i", "name field;
Place the above formula in detail section and suppress the details section.
display:
whileprintingrecords;
stringvar i;
country field" - "i;
Place the above formula in group footer and right click go to format field and check the option "can grow" in common tab.
My today issues is that I'm still looking for concatenation but I need it in the Header of the Group, not in the footer
As far as I understood
- Crystal Report is reading line by Line, so I can't retrieve the value in the Header before the value are calculate.
- Moreover I've issue on initialize the value
I thougth an GlobalVar Array can work, but I can't find the way to do it
My request is, I've have this DataSet
Paris | Louvre
Paris | Eiffel
Sydney | Opéra
I'm looking Group on City to have in the Header, the value concatened
Paris | Louvre, Eiffel
Sydney | Opéra
Thanks in advance
Edited by: Alexandre VANNIER on Dec 2, 2008 2:09 PM