hi friends ,

We have a requirement that whenever there is a grouped column in a report and that report is exported to excel format. Then the cells in the grouped column be merged so that there are no empty cells in that grouped column. Please try the below code as an example,

There you can find that the column DIV having blank cells AS it is a grouped column.

What we want is those empty cells to be merged into one.

SET PRINTPLUS = ON
SET EMPTYCELL = ON
SET GRID = ON
TABLE FILE EMPDATA
BY DIV
BY DEPT
BY FIRSTNAME
BY LASTNAME
HEADING
" Ref: R1295 <+0> <+0> Commercial in Confidence<+0>Run on: &DATEDMYY "
" <+0> <+0> "
" Year: 2007<+0> Period: 09"
" Division: <+0>IS"
" Department: <+0>IS"
" Acct: 83505"
FOOTING BOTTOM
" Page "FSL Commercial in Confidence"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='A4',
LEFTMARGIN=0.180556,
RIGHTMARGIN=0.180556,
TOPMARGIN=0.097222,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
BOTTOMGAP=0.027778,
$
TYPE=FOOTING,
BORDER=LIGHT,
BORDER-COLOR=RGB(66 66 66),
COLOR='WHITE',
BACKCOLOR=RGB(189 190 194),
BOTTOMGAP=0.097222,
JUSTIFY=CENTER,
$
ENDSTYLE
END

I have searched the forum..Found nothing concrete..

Thank you very much

Looks like all of your code didn't make it into the post (the footing bottom part is messed up). When posting code, please include it between

[code]

[/code] markers.

I'm not quite sure what you mean by "merging into one." You can fill in the appropriate values when exporting to Excel by including SET BYDISPLAY = ON or I usually use it as follows in the ON TABLE section:

-IF &OUTPUT NE 'EXL2K' THEN GOTO NODISPLAYBY;
ON TABLE SET BYDISPLAY ON
-NODISPLAYBY

hmmm thanks darin...

Hmmm After opening the spreadsheet , we can merger empty cells into one. In the sense , remove border lines between two adjacent cells.

I searched the forum , i guess i will use BYDISPLAY in Excel..

Thanks DARIN