Reports in Excel format

[ronmont]

I have several users who want to run reports in Excel format so they can take the information and re-sort it, add their own calculations, and generally massage the data. They used to do this in Seagate Info 7 and it worked great. After converting to CE 8.5, however, running a report in Excel format adds blank columns, merges some columns, and makes other changes so the report will print out in a readable fashion. Unfortunately it makes it very difficult for the users to manipulate the data as they are used to doing.

Are they any fixes, patches, etc. that you know of that will help?

 

[synapsevampire]

You should ritually apply the monthly hotfixes:

http://support.crystaldecisions.com/updates/default.asp?ref=default.asp_selectlist_hotfix

-k

 

[MJRBIM]

There are also a bunch of Excel formatting PDFs on the Crystal Decisions web site that show you best practices for formatting your Crystal reports for better Excel export.

Just search the knowledge base and tech docs at

http://www.crystaldecisions.com/

 

[tb]

I had the same problem and took out the Export button on the tool bar - placed an Export menu option and use the CRAXDRT.Report to export . . .

With CrxRpt.ExportOptions
.DestinationType = crEDTDiskFile
.DiskFileName = sNewReportName & ".xls"
.FormatType = crEFTExcel80
End With

 

[ashudubey]

sir,
I am facting problem in Crystal Report 7.0, I want to change the ole object or picture through VB6 , than what should i code that impage will pass through vb form,
suggest me