Skip to Content
0
Former Member
Dec 02, 2008 at 01:02 PM

Data Concatenation - Looking to have result in the Group header

60 Views

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