VB.NET and Export to Excel (Data Only)

[jkb17]

Hello,

I'm trying to programmatically export a report to the excel format. Crystal has two types of excel export: simple and data only. The simple has misaligned columns and looks just like the report. In other words, its usless for data manipulation.

My users love the Data Only version which seems to NOT be available from the object model.

I am using asp.net (with vb.net) version 2.0 in Visual Studio 2005.

Does anybody know how to replicate the Data Only format in code?

thanks

Jim

 

[Madawc]

I don't know anything about Visual Studio 2005. But since no one else has answered, I'll try.

In 2003, there was a change in Crystal 8.5 exporting that improved it a great deal. If your export-choice says things like Excel Extended rather than MS Excel 97, then an update may fix it. I'm not sure if 'BO' still have them for Crystal 8.5 customers.

Failing that, a bit of adjustment can improve the look. Blank text-boxes at the right places will guide the export software to what you actually want.

Another alternative is to do two versions of a Crystal report, one for display and the other for export. Or have them as alternatives within a single report, controlled by a parameter and section suppression. Right-click on the section and choose Format Section. Then choose the formula icon (x+2 and a pencil) for suppression.



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10