Export to Excel Data-Only Issue

[Former Member]

Hi,

I need to export a crystal report into .xls format WITHOUT header.

When i export it normal in xls format (with Header) it displays right. But when i Export it in .xls Data-Only format it removes the Header, but

it overlaps some rows (It changes the Format.). Is there another way to removw Header from .xls report?

Thanks

[former_member183750 · Accepted solution]

See the [Rules of Engagement|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement]

Step 2 Asking Your Question; Provide Enough Information

Also, see [this|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/12045] [original link is broken] [original link is broken] [original link is broken]; blog.

For starters please provide the following information:

What version of Crystal Reports are you using?

What CR Service Pack level are you at?

Is this happening when exporting form the CR designer, or from an application written by you?

If an app, what CR SDK are you using?

If you are using .NET, what version of .NET?

If you are using .NET, is this happening on your development computer, or after you deploy the app?

Is is a web or a win app?

Ludek

[Former Member · Accepted solution]

Ludek,

The Export is happening from a Web 2.0 Application (.Net 2005) Through Crystal Designer.

I am using "Product Version: 11.5.0.608" NO Service Pack Under Windows 2003 Server

Thanks

[former_member183750 · Accepted solution]

OK. 1st thing I would recommend is applying the latest Service pack from [here|https://smpdl.sap-ag.de/~sapidp/012002523100013876392008E/crxir2win_sp5.exe].

If that does not help, and since this is also happening in the CR designer, post your query in the report Design forum (as always, if it don't work in the designer, it ain't gonna work in an app). See if they can help you out there. Once it is working as needed in the designer, test it from the app. If at that point you see issues in the app, post them in this forum.

Ludek

[Former Member]

No response after 2 months. Closing.