Solved

Crystal Enterprise - Report Viewer Error - The export format 'U2FXLS:5' is not supported

Posted on 2004-10-26
1,451 Views
Last Modified: 2012-06-27
I recently had a question answered on how to fix the authentication type drop-down list on the Crystal Report Viewer logon page in Crystal Enterprise 8.0 ( http://www.experts-exchange.com/Databases/Crystal_Reports/Q_21165957.html ).

Having fixed this problem by copying the later version of the file Wcs_xn_reportviewer.dll to the C:\Program Files\Seagate Software\WCS\Components directory, I now find that some reports will not export to Excel from the viewer.  I get the error message:

The export format 'U2FXLS:5' is not supported. [On Page Server: CRYSTAL.pageserver]

This is the problem I had as a result of applying Crystal Enterprise 8.0 Service Pack 1, which led to me reinstalling CE, which led to the logon page drop-down list problem, which I fixed, which led back to having the problem I started with - not being able to export some reports into Excel format.

I need to know how to fix this issue without reinstalling and re-creating the other problem I just fixed.

I have already spent a fair bit of time researching a solution to this one, but as noted ended up reinstalling as a last resort.
0
Question by:STGF
    7 Comments
     
    LVL 28

    Expert Comment

    by:bdreed35
    So some reports will export to Excel without a problem, but then certain ones throw an error?

    Do you have Crystal Reports 8 or 8.5 on the same machine as the machine that is runnig CE?  If not, I recommend installing it and opening the reports from within CR on the server and testing them.  The bsic rule is that if you can run the report in CR on the same box, then CE should be able to execute the report as well.
    0
     
    LVL 42

    Expert Comment

    by:frodoman
    Is there a common thread to the reports that won't export?  For example are the problem reports the only ones with subreports?  Do they all hit the same database?  etc.?
    0
     
    LVL 100

    Expert Comment

    by:mlmcc
    0
     

    Author Comment

    by:STGF
    I have run a couple of reports on the server machine, which has CR 8.5 installed as well as CE 8.0 Standard.  It seems that The reports that are exporting OK in the Crystal Viewer export OK from CR to Excel 8.0 format.  The reports which won't export from the viewer create an error in CR and the program shuts down.

    The reports which generate errors in CR on the server machine are exporting OK from CR on workstation machines.

    All reports hit the same database.  There is no common thread that I can identify which distinguishes the reports which will and won't export.
    0
     

    Author Comment

    by:STGF
    I looked at the version of the file U2fxls.dll (in the C:\WINNT\Crystal directory) on the server machine, and it was 8.6.0.306.  On the workstation, it was 8.5.0.99.  I copies the older version on to the server machine and renamed the newer version.

    This appears to have fixed the problem with CR generating an error when exporting, but at this stage, it doesn't appear to have helped with the viewer export error.
    0
     

    Author Comment

    by:STGF
    I seem to have fixed this problem myself, but I'm not sure how.  I copied the older version of Wcs_xn_reportviewer.dll (refer http://www.experts-exchange.com/Databases/Crystal_Reports/Q_21165957.html) back into C:\Program Files\Seagate Software\WCS\Components, which gave me my original problem back.

    I then copied the newer version of Wcs_xn_reportviewer.dll back in again, and the exporting works fine.

    Thanks for your help, sorry I can't describe better what the problem was or how I fixed it!
    0
     

    Accepted Solution

    by:
    Question answered by asker or dialog valuable.
    Closed, 500 points refunded.
    ee_ai_construct (replacement part #xm34)
    Community Support Admin
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Want to pick and choose which updates you receive? Feel free to check out this quick video on how to manage your email notifications.
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    846 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now