Solved

Crystal Report Export List not showing Excel Option

Posted on 2010-08-26
11
1,474 Views
Last Modified: 2012-05-10
I have a program that uses a Crystal Reports Viewer to show its reports.  So, I don't actually have the Crystal program installed on the server.  We use remote Desktop to access the program on the server. (server 2003)  The Crystal Reports Viewer was installed as part of the program we are using. (Made2Manage)  The problem is that when I (as an admin) log into the program and run the report and then select the option to "Export" the results, I can get the option to export to Excel.  It will show in the list of options.  When I log in as another user (without admin rights) that option does not show. So, this leads me to believe it is a securities issue.
I have tried giving the user admin rights.  I have removed them from the GPO.  I have given the directories where the CRXF_XLS.DLL file is located, both the "Program Files" folder and the "System 32" folder, full permissions.  I did a search of the registry and where I found the file, i changed the permissions there also.
None of these have worked.  I cannot figure out how to get the Excel option to show in the Export list.
Does anyone have any ideas?
0
Comment
Question by:bgfullerton
[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
  • 6
  • 4
11 Comments
 
LVL 11

Expert Comment

by:tickett
ID: 33532787
Can you take a screenshot of the export dialogue? I'm curious whether it is actually the Crystal dialogue or something being presented by the application. If that is the case it might be configurable within the application?

L
0
 

Author Comment

by:bgfullerton
ID: 33533544
Here are 2 screen shots.  One with my login that shows the Excel selction that can be selected and one screenshot that shows there is no Excel selection to be choosen.
Screen-shot-with-My-login.jpg
Screen-shot-with-User-Login.jpg
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 33535195
What version of Crystal are you using?

Since you have CR 7 format available, I assume you are using CR8 or CR8.5.

If it is CR8 then the export dll is u2_xls.dll or something like that.  Crystal change the export file names in either CR8.5 or CR9.  Since I haven't used CR8.5, I am not sure which version changed it.

mlmcc
0
Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

 

Author Comment

by:bgfullerton
ID: 33535355
I am not exactly sure what version it is.  Like I said before, it was part of the install package from the software installed to view some of the reports from a Made2Manage application.  Looking at some of the files in the Program Files directory, I would guess it was version 11.5.  See the attached picture.
Screenshot-of-File-Folder.jpg
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 33537000
Since you have CR7 ormat available, it can only be CR8 or 8.5/  Later versions couldn't export to CR7 format.

Do you also see a Seagate Software directory?

mlmcc
0
 

Author Comment

by:bgfullerton
ID: 33540958
Yes, there is a Seagate dir. Not much in it though.
Seagate-Folder.jpg
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 33547520
That looks like CR8 files.  Look for a U2XLS dll or perhaps it is P2XLS

mlmcc
0
 

Author Comment

by:bgfullerton
ID: 33557587
I did a search of the entire C drive for either of these files and it come up empty.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 33563468
Unfortunately I don't have  CR8 installed anywhere and I am using my memory for the file names.

I do have CR7 installed on another machine but not sure what is there.  I'll look to see if I can find them.

mlmcc
0
 

Author Comment

by:bgfullerton
ID: 33578173
I am still trying to figure this thing out.  I have tried installing Crystal Reports 8.5 onto the server with no luck.  I found a U2XLS.dll file on another server that was using the same type of viewer and I copied that file into the "C:\Program Files\Business Objects\Common\3.5\bin" folder and that did not work either.  Does someone know what populates the drop down list when you go to export the report to a file?  If I knew where the information for this list comes from, I might be able to figure out why it populates for me and not for the normal user.
0
 

Author Comment

by:bgfullerton
ID: 33580626
Problem solved.  I found the U2FXLS.DLL file and placed it in the System32 dir.  Everything showed up like it was supposed to.  I still do not know why it showed up for myself and not others but at least it works now.  On to the next puzzle.
mlmcc, you did not have the entire correct answer but you did lead me in the right direction.  Thanks for the help.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

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…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

621 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