-
Dec 9th, 2017, 04:06 PM
#1
Thread Starter
Hyperactive Member
[RESOLVED] Problem Exporting a Crystal Report 8.5 Report to Excel
I'm trying to export a Crystal Reports 8.5 report to Excel via VB6 code but is getting a weird message:
Window name: Crystal Reports: Database Error
Error Message: 'Index_0DF0A39F_DFB4_469C' is not an index in this table.
Just before this message appears there is a window 'Exporting Records' with Current and Total etc.
Does anybody know what this means or what I'm doing wrong?
I create a few temporary tables and populate them with the data I need in my report. When I open the tables they show that the fields are indexed that are used in the report links. Displaying and printing the report from VB6 works. The exporting to Excel doesn't work...
This has been frustrating me for days now and I can't figure out what the hell is wrong
-
Dec 10th, 2017, 06:45 AM
#2
Re: Problem Exporting a Crystal Report 8.5 Report to Excel
Since you want to go (or export) from:
- DataBase -> to Excel
At which point does Crystal-Reports come in?
Is this only about "fancy formatting"?
If yes - why don't you do that in Excel itself then?
Or if it's more like "Sums and Totals", that reads more like a task I'd handle on the DB itself - per SQL.
Olaf
-
Dec 11th, 2017, 12:35 AM
#3
Thread Starter
Hyperactive Member
Re: Problem Exporting a Crystal Report 8.5 Report to Excel
It's an existing report that was printed before. Wanted to export that report to Excel and PDF for electronic submission.
Thought exporting it from the original report would save some time and hassle. BIG mistake. The hours I spend with this problem I could have programmed the export to Excel in coding. This is the route I'll have to look at now but it still leaves me with the problem of exporting it to PDF.
-
Dec 13th, 2017, 04:55 PM
#4
Re: Problem Exporting a Crystal Report 8.5 Report to Excel
To get a .pdf version of the report, a .pdf printer driver might be the easy way to go.
-
Dec 13th, 2017, 11:51 PM
#5
Thread Starter
Hyperactive Member
Re: Problem Exporting a Crystal Report 8.5 Report to Excel
That is what I'm suggesting until I can get the export working. Want to do the export to minimize user intervention. The less user intervention is needed the less chance of a buggerup
-
Dec 13th, 2017, 11:58 PM
#6
Thread Starter
Hyperactive Member
Re: Problem Exporting a Crystal Report 8.5 Report to Excel
From what I can gather from googling is that I (maybe?) don't have all the files needed for the export. Apparently there is a file called ExportModeller.dll that must be included in the setup but that file is non existent on my CR8.5. I installed service pack 2 and still no file by that name. And for the life of me I can't find service pack 3 on the net to download. All the links I did find were all dead ends
So I'm still stuck!
-
Dec 14th, 2017, 10:55 AM
#7
Re: Problem Exporting a Crystal Report 8.5 Report to Excel
Possibly useful link:
http://support.cyriouswiki.com/Cryst...r+Installation
Note: I have not checked any of these files for potential malware. You may want to do so before using them.
-
Dec 14th, 2017, 04:13 PM
#8
Thread Starter
Hyperactive Member
Re: Problem Exporting a Crystal Report 8.5 Report to Excel
Thanks. I'm going to try this.
-
Dec 19th, 2017, 05:49 AM
#9
Thread Starter
Hyperactive Member
Re: Problem Exporting a Crystal Report 8.5 Report to Excel
Did not help with the error message but eventually found some answers on mahipalreddy.com that fixed the export to PDF problem.
Now to figure out to export to Excel
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|