Results 1 to 9 of 9

Thread: [RESOLVED] Problem Exporting a Crystal Report 8.5 Report to Excel

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2007
    Location
    Roodepoort, South Africa
    Posts
    472

    Resolved [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

  2. #2
    PowerPoster
    Join Date
    Jun 2013
    Posts
    7,207

    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

  3. #3

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2007
    Location
    Roodepoort, South Africa
    Posts
    472

    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.

  4. #4
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,391

    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.

  5. #5

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2007
    Location
    Roodepoort, South Africa
    Posts
    472

    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

  6. #6

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2007
    Location
    Roodepoort, South Africa
    Posts
    472

    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!

  7. #7
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,391

    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.

  8. #8

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2007
    Location
    Roodepoort, South Africa
    Posts
    472

    Re: Problem Exporting a Crystal Report 8.5 Report to Excel

    Thanks. I'm going to try this.

  9. #9

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2007
    Location
    Roodepoort, South Africa
    Posts
    472

    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
  •  



Click Here to Expand Forum to Full Width