I have crystal report with 2 page headers (PHa and PHb) when i export this report to excel by selecting Excel (Data Only ) option the PHa is missing the exported excel.I tried to suppress the PHb to display PHa when it is exported to excel but by doing so the output excel has not heading displayed.
A:
If you are doing this from Crystal, try the following.
When you export to Excel (Data Only), under the Excel Format Options, choose Custom.
Expand the Options.
Ensure to uncheck Simplify page headers
astander
2009-12-23 06:42:07
Thanks. That works
radhika
2009-12-23 06:48:44