Cannot Export files using Excel in my application(in which i am using crystal re

I am using crystal report for reporting in my application but in some computers the application does not show the export option in Excel, i export mostly in excel for reporting but this problem occurs in some computers rest of the computers are exporting normaly i have already installed MDAC 2.8 but could not solve that problem is there any solution then please let me know thanks.Each Export format (Excel, pdf, etc) and each Export Destination (Aplication, Disk, etc) has to have a dll installed on the machine it's running on. If, for example, you can export to pdf, but not to Excel, your problem may be that the dll required for Excel Export is missing.

In Crystal Reports 8.5, there's a file called runtime.hlp that tells exactly what dlls are required depending on what your application uses.

(Ex. For CR 8.5 and Win2k, my Excel export dll is: C:\WINNT\Crystal\u2fxls.dll and my dll for Exporting to Application is: C:\WINNT\Crystal\u2dapp.dll)sql

Cannot Connect to Analysis Services Olap Server

When attempting to connect to a Microsoft Analysis Server from the Crystal Report (v10), the following error message appears:

"The connection could not be established. The logon attempt failed".

I am using Windows XP Pro.

Why is this happening? At the Crystal Report I am using the wizard to create a new report and specifically I am using at the Server options the 1st one (where I specify the Server Name, User Name & Password). Also the 'Server Connection' is 'Direct to the OLAP Server'.

Both the Crystal Report & Analysis Services are running under the same PC, thus there are no network connectivity issues.

I also tried to connect using the Excel to the Analysis Services (where I used the same UserId and Password, to the one I tried with Crystal Reports) and the connection was succesful.

I also checked the Firewall settins, and its ok as the Crystal Report is under the Excpetions.

Why then can't I connect?

There are quite a few questions related to troubleshooting connectivity problems.

First you need to see if you have problem connecting to Analysis Services.
See if this post is going to help you: http://www.sqljunkies.com/WebLog/edwardm/

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.