Export Crystal Reports from VBA (Crytsal 11)


Have been using the following code for a little while to export Crystal 9 reports to pdf and then email

have now upgraded to CR 11 and get a message that the report was created in a different version and then i have to verify the database

Does anybody know of a way of hiding these messages, i run the app over night and want it to progress automatically without having to click ok to all the prompts.
Dim appl As New CRAXDDRT.Application
Dim rep As CRAXDDRT.Report

Set rep = appl.OpenReport("D:\NA_RMA\snhist.rpt", 1)
rep.ExportOptions.DiskFileName = "D:\NA_RMA\snhist.pdf"
rep.ExportOptions.DestinationType = crEDTDiskFile
rep.ExportOptions.FormatType = crEFTPortableDocFormat
rep.Export False

Open in new window

I use crviewer9.dll and craxdrt9.dll , cant find a cr11 version of these files to try

Any help would be great

Who is Participating?
Which edition of CR XI do you have?
If you have the developer or advanced edition you should have CRAXDRT for CR XI available.  You could upgrade the app to use it.

Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Open the report in Crystal Designer and use the menu option of
Database, Verify Database...

Then, save the rpt.
JapesAuthor Commented:
Thanks, but i think the problem is more to do with using version 9 of craxdrt and crviewer with reports written in cr11, if i verify the database in cr11 i still get the message relating to the report being written in a different version of the software when running my app

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

JapesAuthor Commented:

Just purchased CR XI Developer as only had standard before, should be available for download soon, will try tomorrow.

Thanks for taking the time to advise - i will be overjoyed if it is the solution!
You should just have too update the application to use the CR XI CRAXDRT and CRViewer.

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.