[RESOLVED] Excel Option Not Available in Export List

[Trusted4U]

Hello Everybody,
I am using crystal reports 8.5. When I run this report on my machine and click on export button, it lists all the applications where I want to export my report for eg :
Adobe Acrobat [PDF]
Excel 5.0 [XLS] Extended
Excel 7.0 [XLS] Extended
Excel 8.0 [XLS] Extended etc. But when I run the same report on client pc it doesn't show Excel options in the list at all. I have copied CrxlAt32.dll and U2fxls.dll in system32 folder of the client pc but invain.
When I tried to register u2fxls.dll with regsvr32 command, it says entry point could not be found.
This problem is really driving me crazy. Pls help me.

Thanks,
- Marjo.

[RobDog888]

When you use the export function of CR you can only export into
Excel if the workstation has Excel installed on it. Otherwise there
are no Excel COM objects for it to use, kind of like a printer driver
thing.

If the workstation has Excel, then try creating a setup package
so it can gather all the dependancy files for CR.

[Trusted4U]

Thanks for replying. The client pc has excel. I also copied all the .dep files from my pc to the client pc but its still not showing the excel option in the export list.

[Trusted4U]

Please Help

[RobDog888]

Ok, now this is new to me too, I have a new system at
home where I haven't installed any Office applications yet. I do
have CR on it already and there is the option to export to Excel
formats. CR must be using its own drivers to simulate an Excel file
format. So its not relying on the system to have Excel installed.
On your problem, you must have a CR issue and not an Office
issue. Not too sure, but could it be an issue that applies to all CR
reports on this system and not just the one youu created?

HTH

[Trusted4U]

You are right RobDog888, its not an excel installation issue but a CR issue. I started facing this problem since the networking guys did windows update last week. Prior to that, the excel option was listed in the export list and everything was just perfect. And this problem is related to all CR reports running on client machine. I mean, regardless of which report I run, the excel option is not listed in the export to list at all.

I am also trying to find a solution solution from CR forums and a similar problem was reported by someone. The solution provided was, download module.zip [ module.exe ] and run it on both client and developer pc. It will list all the dll files then compare each file from the developer pc with the client pc and find out which one is missing.
I downloaded and tried It but its really painful. I am not able to determine what is causing the problem.

Thanks,
- Marjo.

[ARPRINCE]

Do you have the file CRXF_XLS.DLL in the CR bin directory of the client PC or anywhere for that matter? Try registering this one too.

[brucevde]

The Export functions need two dlls to operate properly. You must install the dlls beginning with U2F and U2D. These dlls do not need to be registered but need to be located within the current system path.

Check the runtime.hlp help file in your Crystal folder (can't remember the exact path) for more information.

[Trusted4U]

The Export functions need two dlls to operate properly. You must install the dlls beginning with U2F and U2D.

Do you have the file CRXF_XLS.DLL in the CR bin directory of the client PC or anywhere for that matter? Try registering this one too

The client machine has all these dll's. Before posting this thread,I had tried copying
CRXF_XLS.DLL
CRXLAT32.DLL
U2FXLS.DLL
ALL U2D*.DLL FILES.
Infact when all my attempts failed I got bugged and I copied all the crystal dll's from my pc to the client pc. But still there is no sign of excel option in the export list.
I also tried to remove u2fodbc.dll, u2fwks.dll, u2fwordw.dll just to check whether their corresponding applications are removed from the export list. And it works fine. If the urf* exists in the system32 folder that application will be available in the export list.

THEN WHY THE HELL U2FXLS.DLL IS NOT AFFECTING THE EXPORT LIST ??????

[RobDog888]

What windows update did the networking guys do? Maybe there
is a KB article on this at M$.

[billcoupe]

The first thing I'd do is create an install package, and then install it on a different machine.

If the new install works fine it's a problem related to that machine, possibly a registry issue or any other OS related issue.

If the problem persists on another machine, I'd suspect your VS.Net installation... at least the Crystal components as the culprit.

[Trusted4U]

RESOLVED
I found it. Crxf_xls.dll was the culprit.
It was disabling the functionality of U2fxls.dll. I deleted it from the client pc and voila !!! the excel options are now available in the export list.

Thanks A Lot To All Of You For Your Help.

Bye .

- Marjo.

[RobDog888]

What is the file for (Crxf_xls.dll)? I searched on my system and I
don't have it. I am running CR Developer 8.5. I just wanted to
know for future reference.

Thanks

[brucevde]

Crystal is known for causing DLL Hell. This will explain the problem.

Crxf_xls.dll does not allow exporting to older version of Excel

[RobDog888]

Thanks Brucevde

[chocoleño]

Hi, I really wish to thank them for their contribution. I also had the same problem and resolved thanks to you. Thanks trusted4u...