I m trying to export a report (9) through a vb application but i keep getting this error. can any one tell me what is the problem
thanks
Printable View
I m trying to export a report (9) through a vb application but i keep getting this error. can any one tell me what is the problem
thanks
You are going to have to provide more information if you want help. What database, what is the error, and try to post some of your code.
the code is as followsSQL server 2000 at the back..but i just dont know what is the main problem..i have read the other threads but when i try to use the information ..it gives me this error..and i am not running ona client machine.VB Code:
Private Sub LoadCheckSheet() 'On Error GoTo ConnHandler Set crystal = New CRAXDRT.Application Set Report = New CRAXDRT.Report CRViewer.DisplayTabs = False CRViewer.EnableDrillDown = False CRViewer.EnableRefreshButton = False CRViewer.EnablePrintButton = True CRViewer.EnableExportButton = True CRViewer.DisplayGroupTree = False conn.Open ConnectionString rs.Open "SELECT * FROM OrderTableSummary", conn, adOpenStatic, adLockReadOnly Set Report = crystal.OpenReport(App.Path & "\CrystalReports\testing.rpt") 'OPEN OUR REPORT 'On Error GoTo LoadError Report.DiscardSavedData 'CLEARS REPORT SO WE WORK FROM RECORDSET Report.Database.SetDataSource rs 'LINK REPORT TO RECORDSET CRViewer.Refresh CRViewer.ReportSource = Report 'LINK VIEWER TO REPORT CRViewer.ViewReport 'SHOW REPORT Report.Exportoptions.DestinationType = 1 Report.Exportoptions.FormatType = 31 Report.Exportoptions.DiskFileName = "c:\my.pdf" Report.Export True Do While CRViewer.IsBusy 'ZOOM METHOD DOES NOT WORK WHILE DoEvents 'REPORT IS LOADING, SO WE MUST PAUSE Loop 'WHILE REPORT LOADS. CRViewer.Zoom 94 rs.Close 'ALL BELOW HERE IS CLEANUP Set rs = Nothing conn.Close Set conn = Nothing Set crystal = Nothing Set Report = Nothing Exit Sub LoadError: MsgBox "Application Error: 200! An Email would be sent to notify the System Administrator of the problem!", vbCritical, "BIOSOFT - Message!" conn.Close Set conn = Nothing ConnHandler: MsgBox "Application Error: 400 Not Connected To DataBase", vbCritical, "BIOSOFT - Message!" End Sub
Edit: Added [vbcode][/vbcode] tags for more clarity. - Hack
can anyone plz help me
I have tried to export even from the crystal report 9 software but i get the message report export failed...i register the xport modeler and cltsv.dll file too..which it register but when i tried to register crx_pdf.dll..something like that it fails..i dont know what is the problem..its strange that it is not exporting from the development machine where the crystal report is installed.
Oh. You are trying to run it on a different machine? Check out the application deployment forum. RobDog888 has posted a few times about what is required to deploy an app with CR. I think there's a help file or something that lists dependencies that you have to have on the machine.
Well i m not deploying it for now. What i am doing is that i have installed crystal report 9 on the my machine. I create a report in crystal report 9 and when in that i export it it gives me the error failed to export report..i reinstalled it and even then i m getting the error.. so that means that the dll file is not registerd..what can i do to solve it
I'm not sure, because I don't have CR. Did you install from the original CD? Did you uninstall it before re-installing?
i can export it in html now cause when i try to do it it install some files so it does in xml and html and with each type of export now it appers a non 1 that means that it can be exported in that format but for adobe it does not..so do you think i have to install it all over again and make sure that it installs every bit of it. i just figure this out. do you think the same.
Make sure that you un-install it first. I would also use Add/Remove Programs to do both steps. Things seem to work best this way, rather than just using the CD. Do a FULL INSTALL. I agree.
i have done everyting but i cannot export it from the crystal report designer
The following are the PDF Export DLL's required to successfully have Crystal Reports 8.5 create a PDF file:
1. crtslv.dll
2. crxf_pdf.dll
3. crxf_rtf.dll
4. ExportModeller.dll
5. u2ddisk.dll
6. u2dpost.dll
7. u2fcr.dll
8. u2fhtml.dll
9. u2fwordw.dll
10. u2fxls.dll
11. u2fxml.dll
Files that need to registered on the local system:
1. c:\winnt\system32\crtslv.dll
2. c:\winnt\system32\ExportModeller.dll
I am having this problem as well, but only on a Vista machine that has Adobe 9 installed. If I run the same program from Windows XP with Adobe 9 installed, I do not get the error.
We are running Crystal XI Release 2 w/SP2 RDC methods in our VB6 code.
We have distributed the runtime components for CRXIR2 using the merge modules. I checked both the Windows XP machine and the Vista machine.
All of the PDF Export DLL's with the exception of u2fhtml.dll, u2fwordw.dll and u2fxls.dll are installed on both machines. They all reside in C:\Program Files\Common Files\Business Objects\3.0\bin and the crtslv.dll and exportmodeller.dll are registered on both machines although they are only located in the C:\Program Files\Common Files\Business Objects\3.0\bin folder not the system32 folder. The placement of these files (and registering) is done by the runtime merge modules; we do not manually install the files.
We are running against a SQL database using stored procedures as the main datasource. The report contains several subreports (all having stored procedures as their main datasource). Some of these subreports have only a sql image in them (we are pulling it from our database). We print some of these images based on an input parameter for the report. It is when the user requests these images to print (again based on the input parameter) that the report fails with the error:
Error in Crystal Report: Failed to export the report.
This error occurs only when we try to Export as a PDF.
I have tried deleting and re-adding the subreport as well as removing the image and placing it on the subreport again. All to no avail.
Does anyone have some ideas?
Thank you.
I am having this problem as well, but only on a Vista machine that has Adobe 9 installed. If I run the same program from Windows XP with Adobe 9 installed, I do not get the error.
We are running Crystal XI Release 2 w/SP2 RDC methods in our VB6 code.
We have distributed the runtime components for CRXIR2 using the merge modules. I checked both the Windows XP machine and the Vista machine.
All of the PDF Export DLL's with the exception of u2fhtml.dll, u2fwordw.dll and u2fxls.dll are installed on both machines. They all reside in C:\Program Files\Common Files\Business Objects\3.0\bin and the crtslv.dll and exportmodeller.dll are registered on both machines although they are only located in the C:\Program Files\Common Files\Business Objects\3.0\bin folder not the system32 folder. The placement of these files (and registering) is done by the runtime merge modules; we do not manually install the files.
We are running against a SQL database using stored procedures as the main datasource. The report contains several subreports (all having stored procedures as their main datasource). Some of these subreports have only a sql image in them (we are pulling it from our database). We print some of these images based on an input parameter for the report. It is when the user requests these images to print (again based on the input parameter) that the report fails with the error:
Error in Crystal Report: Failed to export the report.
This error occurs only when we try to Export as a PDF.
I have tried deleting and re-adding the subreport as well as removing the image and placing it on the subreport again. All to no avail.
Does anyone have some ideas?
Thank you.
I am running version 8.6 of Crystal Reports developer. At some point in time, clients reported that PDF exports just quit working. Of course I could not duplicate the problem on the development box. I'm not sure what caused it...maybe XP SP3? After wasting a lot of time this is what finally worked for me. :thumb:
- Install Crystal Reports SP3
- Install Crystal Reports hot fix package DBEXDRVRWIN_EN_200401.EXE
- Make sure the that the client computer has version 8.6.2.440 of ExportModeller.dll
- Make sure the that the client computer has version 8.6.1.726 of crtslv.dll
alweis, I have not been able to find DBEXDRVRWIN_EN_200401.EXE hotfix file or the correct versions of ExportModeller.dll and crtslv.dll. Do you have a link where these files can be downloaded?
Greg,
I have put the file on line at this location.:afrog:
Thanks! That fixed my problem.