Export to Excel Formating Option Problem

[Former Member]

Hi all!

I create a Crystal Reports.when i export to Excel File in a winform app,there has the 'Create page breaks for each page' option,but in asp.net web page.there is only two option,and not include the 'Create page breaks for each page' .I excpet the Excel File was page breaked.

has any ideas?

Thanks!

Ray

[former_member184995 · Accepted solution]

Hi Ray,

What version of VS.NET are you using?

What version of Crystal Reports?

What code are you using to export?

Jason

[Former Member · Accepted solution]

Hi Jason

I'm using VS.NET 2005 and Crystal Reports for Visual Studio 2005.

In my asp.net page,i just using a CrystalReportViewer to render my report.when i click the export button,a pop-up window was shown which has only two option(Export format,page range).

>

> Hi Ray,
> 
> What version of VS.NET are you using?
> What version of Crystal Reports?
> What code are you using to export?
> 
> Jason

[Former Member · Accepted solution]

Hi Ray,

The window that you are getting is an inbuild control or functionality of the Viewer control. The web Viewer and Windows viewer are different controls.

[former_member184995]

You will need to code your own export button if you want to have greater control over how the files are exported.

[Former Member]

Hi Jason

You means i can use code to sepcial the export options to export the excel file,right? Thanks! I'll try it.

And there is a another question,I want the exported excel include freen row and data filter,is it possible? And how do?

Thanks!

>

> You will need to code your own export button if you want to have greater control over how the files are exported.

[former_member184995]

You can use the ExcelFormatOptions to specify what you want the export to look like.

Look for it here:

[http://devlibrary.businessobjects.com/BusinessObjectsXIR2SP2/en/devsuite.htm]

You can also set up the reports export options that you want to always be used by opening the report in Crystal and going to File|Export|Report Export Options.

I am not sure about the 2nd question. You will want to create a new thread for that and someone else may know the answer. Can you do it when you export it from Crystal Reports? If not, then you won't be able to do it from your application.