Cell Merging with excel export
Hi,
I have a report with following layout:
City- Restaurant
City1 Rest1
City1 Rest2
City1 Rest3
There is an option to suppress duplicate records and now my report looks like:
City- Restaurant
City1 Rest1
-
Rest2
-
Rest3
But I want it to look like below (basically vertically central align the City1):
City- Restaurant
-
Rest1
City1 Rest2
-
Rest3
Can it be achieved while exporting to excel.
Please ignore the (----), it actually means the cell is empty
Former Member replied
try using this suppress formula in the for the field.
but first you need to create a summary field that get the count of the records in you group
now create the following formula
place this formula in the group header
whileprintingrecords;
global numbervar counter:=0;
place this formula in the detail section
whileprintingrecords;
global numbervar counter;
counter:= counter + 1
place this formula in the suppress for for the field
whileprintingrecords;
global numbervar counter;
counter <> int(Count ({group summary field)/2+.5)