Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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
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)

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question