Export to excel from crystal reports without page headers/footers

Hi there,

Just wondering if anybody had working code example (in c#) for exporting a crystal report to excel from a .NET application without the report's page headers and footer's.

I am using crystal reports v9 runtime.

From stackoverflow

• To accomplish this you actually need to do it in the Crystal Report. My recommendation is to add a parameter to it, and then edit the header and footer suppress formulas to check the parameter. That was how we accomplished it. If there is way to do it from your code I would be interested in knowing it also.

  Good luck!

  Eduardo Molteni : There is not need to add a parameter, you can suppress the header and footer programatically before exporting.

• try the following link , it is based on vb.net but you will get an idea of how to exporto to excel file.

  http://vb.net-informations.com/crystal-report/vb.net_crystal_report_export_excel.htm

  bolton.