crystalempress
Programmer
We are using CE8.5 and 75% of our reports are exported to EXCEL. There are 2 dll's out there crxf_xls.dll and u2fxls.dll. If we use the crxf_xls.dll then our 99% of our reports won't export correctly, they export into excel in Merged Cells. Everything looks good when you see it but when you have to do anything with this excel file you can't due to how it is exported into merged cells. Yes for the 'experienced' Excel user they can work around this but it takes a little effort. BUT when we use the u2fxls.dll it works just exports just fine. The problem is that u2fxls.dll uses a older version of excel (only up to 8.0) and with crxf_xls.dll it uses the most current version (9.0 or excel 97/2000).
The problem we are having is: with 1 report, there are over 30 some fields we need and we need them exported to excel in one row. In order to do this and fit it all on a crystal report (without going to font size 2), 3 rows of detail were created. In the crystal report you see the 3 rows of detail but when exported to excel data only, it puts all the fields in one row, one field per column. exactly as we want it. (you would think this would be common request from businesses that may need to send out data). THE CATCH, crxf_xls.dll has to be used to make this work, doing this breaks the other 99% of the reports that will now not export correctly to excel(they get merged cells)
We have worked with Crystal Support and determined the difference of .dll's needed to be used to get the reports exporting correctly.
Is there a way we can write the Crystal Report to get all these fields on 1 line and export correctly using the u2fxls.dll???
This same thing is happening on our .NET Crystal applications, but they only have the one (crxf_xls.dll) and putting the u2fxls.dll in doesn't work??
Any help would be GREATLY appreciated.
The problem we are having is: with 1 report, there are over 30 some fields we need and we need them exported to excel in one row. In order to do this and fit it all on a crystal report (without going to font size 2), 3 rows of detail were created. In the crystal report you see the 3 rows of detail but when exported to excel data only, it puts all the fields in one row, one field per column. exactly as we want it. (you would think this would be common request from businesses that may need to send out data). THE CATCH, crxf_xls.dll has to be used to make this work, doing this breaks the other 99% of the reports that will now not export correctly to excel(they get merged cells)
We have worked with Crystal Support and determined the difference of .dll's needed to be used to get the reports exporting correctly.
Is there a way we can write the Crystal Report to get all these fields on 1 line and export correctly using the u2fxls.dll???
This same thing is happening on our .NET Crystal applications, but they only have the one (crxf_xls.dll) and putting the u2fxls.dll in doesn't work??
Any help would be GREATLY appreciated.