Solved

Export Crystal Reports using VB6 CRViewer

Posted on 2004-04-25
10
3,062 Views
Last Modified: 2012-06-27
Hi,
I'm using Crystal Reports 7 for my reports and VB6 as my interface.  I used CRViewer to show the report and i need to export the report to an Excel file or MS Word. Here's the details of the problem.. a. i was able to show the report in the CRViewer.
b. Export menu showed and was able to select the format and destination of the file to be exported.
c. When i tried to open the file i have exported in Excel, i receive an error message "Unable to read file." Then shows a blank spreadsheet.

What can i do to make the export work perfectly?

Regards,
Raymond
0
Comment
Question by:raytwoex
[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
  • 4
  • 4
  • 2
10 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 10918285
So it exports from Crystal okay, but when you try to open the .xls file is when you get the error?

What version of Excel are you using?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 10920235
What version of Excel do you have?

You might look
http://support.businessobjects.com/library/kbase/articles/c2002951.asp

mlmcc
0
 

Author Comment

by:raytwoex
ID: 10923882
The export was successful but when i opened the excel file, the error appeared.
The version of Excel I am using is MS Excel 2002 SP-2.

I saw the link mlmcc provided, does it mean that it only works in MS Excel 97?


Thanks for the quick response.
raymond
0
[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

 
LVL 101

Expert Comment

by:mlmcc
ID: 10924786
No, but CR7 probably can only export to Excel 95 or Excel 97.  Since the file formats may have changed, Excel 2002 may not be able to open the fle directly.

mlmcc
0
 

Author Comment

by:raytwoex
ID: 10925425
Are there any options you can suggest as solution for my problem?

One option I can see is to replace the CR7 to CR8 or higher. But if i do this, I might re-create the reports I already created.

raymond
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 125 total points
ID: 10927828
Before doing that, is there any chance you can find a copy of Excel 97 and install it to see if the file is ok?

CR8 is no longer available though you might find copies on EBay.
CR8 can read CR7 files and update them to the CR8 format.

CR9 also changed the format.  I am not sure if CR9 or 10 can read CR7 files.

mlmcc
0
 
LVL 42

Expert Comment

by:frodoman
ID: 10928409
I agree with mlmcc.  I would check first before spending the money on an upgrade because Excel 2002 should be able to open Excel 97 files w/out difficulty so I would be surprised if that's the problem.

You might also want to try reinstalling Crystal in case the export dll got corrupted somehow.
0
 

Author Comment

by:raytwoex
ID: 10936825
I won't be able to get a copy of Excel 97. I'll try reinstalling  CR7 and then try again if export will work.

raymond
0
 

Author Comment

by:raytwoex
ID: 10983151
Hi guys, I was able to re-install CR7 and tried exporting again using my VB application. Its now exporting as expected.

Thanks for all the help.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 10983211
Glad I could help

mlmcc
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying 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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

617 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