Cell Merging with excel export

This question is answered

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

Correct Answer

May 14, 2009 at 18:06 PM

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)

0 Likes 0 View this answer in context