Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2004-10-26
7
Medium Priority
?
1,472 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
Comment
Question by:STGF
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 28

Expert Comment

by:bdreed35
ID: 12409952
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
ID: 12410284
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 101

Expert Comment

by:mlmcc
ID: 12410464
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:STGF
ID: 12416925
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
ID: 12417075
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
ID: 12520584
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:
ee_ai_construct earned 0 total points
ID: 12520892
Question answered by asker or dialog valuable.
Closed, 500 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

610 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