cancel
Showing results for 
Search instead for 
Did you mean: 

Cell Merging with excel export

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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)

Answers (0)