Hi,

Iam creating a Pivot Report and Table Report in a Excel. There is a issue in pivot output.
The filter drop-down(default pivot option) is showing in row value. pls find the below image

https://goo.gl/photos/qeXbrLg5NrG5gcCfA

if i move the values from "Row Labels" to "Column Labels", two column titles are showing. pls find the below image.

https://goo.gl/photos/q95dDGE9256ncNeT9

This happens only if i add Heading to the report.
How to fix this issue.
Pls help me on this..

below is my code.

 
TABLE FILE CAR
PRINT 
     CAR.BODY.SALES
     CAR.BODY.DEALER_COST
BY  LOWEST CAR.COMP.CAR
HEADING
"Client " 
"Summary"
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K OPEN PIVOT
CACHEFIELDS CAR.BODY.BODYTYPE CAR.CARREC.MODEL CAR.ORIGIN.COUNTRY
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END


TABLE FILE CAR
PRINT *
BY COUNTRY NOPRINT
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K CLOSE 
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END


 

This message has been edited. Last edited by: Maran,

This issue was solved.

If we remove the "ON TABLE SET PAGE-NUM NOLEAD" command, The Pivot looks fine..