?
Solved

VB 6.0 app using Crystal ocx

Posted on 2003-04-01
6
Medium Priority
?
419 Views
Last Modified: 2012-05-04
I have a VB 6.0 application using the crystal ocx.  The report was created in Crystal 8.0.  Here are my report properties:
   CrystalReport1.Destination = crptMapi
   CrystalReport1.EMailSubject = "New Hire - Rehire Report"
   CrystalReport1.EMailToList = "hayes heather"
   CrystalReport1.PrintFileType = crptExcel50
   CrystalReport1.Action = Enabled
When a field on the report is 0 it is displayed as "<Default Format>" in the excel spreadsheet.  I have tried just exporting the report with crystal to excel and it works fine, but I get different versions of excel to export.  I believe I am having problems because I am exporting to Excel 5.0.  I have Excel 2000 loaded on my client machine.  Is there a way to update the ocx to have the option to export to Excel 7.0?
       
0
Comment
Question by:heatherh
6 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 8250409
You need install the export dlls.

To use Excel 2000 you may have to upgrade the version of CR.

mlmcc
0
 

Author Comment

by:heatherh
ID: 8254125
I have searched Crystal's knowledge base and the only export dlls I have found related to this issue are for version 6.0
Can you tell where I can find these dlls?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 8257491
I don't know.  I believe the Excel 7 dlls came with my copy of CR8.

I'll look in the morning to see if we downloaded an upgrade.

mlmcc
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:heatherh
ID: 8263058
Did a little more research and found out the the crystal ocx does not have an option to set the PrintFileType property to a version higher than excel 5.0.
In the mean time live with the bug until time permits to upgrade to CR 8.5
thanks for your help
hh
0
 

Expert Comment

by:CleanupPing
ID: 8531182
Hi heatherh,
This old question (QID 20570508) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
0
 
LVL 6

Accepted Solution

by:
Mindphaser earned 0 total points
ID: 8534802
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses

579 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