Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1717
  • Last Modified:

Failed to Export the report while mailing report thru vb6 application

i have vb 6 & crystal report 8.5 application. till now i am able to send email via following code. but suddenly it is not working an dgiving error  - RUN-TIME '-2147190908(80047784)';
FAILED TO EXPORT THE REPORT.

code is \
report1.exportoptions.DestinationType = crEDTEMailMAPI
report1.exportoptions.FormatType = crEFTPortableDocFormat
report1.exportoptions.MailtoList = "abc@yahoo.com" ' email id
report1.exportoptions.NailSubject = "Subject "  ' subject
report1.exportoptions.PDFExportAllPages = true
report1.Export False <--- it gives error here --->>

0
Nitin Shah
Asked:
Nitin Shah
  • 5
  • 3
  • 3
1 Solution
 
JayConverseCommented:
"Suddenly it is not working"  

What changed on the PC?  What other software was installed, like another program that uses Crystal?  Does it export with different selection criteria?
0
 
mlmccCommented:
Agree.  Something must have changed.

Is this on a client machine or is Crystal and VB6 installed?

mlmcc
0
 
Nitin ShahAuthor Commented:
The computer has got VB6, crystal report and sql 2000. application generate reports from DSR and export it in pdf format as attachment in mail.  operating system in windows 7. i can export in report mode thru export option in crystal report as pdf file. but not as attachment in mail
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
mlmccCommented:
What Crystal references are you using in the report?

mlmcc
0
 
Nitin ShahAuthor Commented:
Crystal References are

1. crystal report viewer control
2. crystal report 8.5 activex designer design and runtime library
3. crystal report 8.5 activex designer runtime library

Crystal Components are
1. crystal report viewer control (crviewer.dll)
0
 
JayConverseCommented:
Windows 7 does not allow MAPI, that's why email isn't working.  Crystal XI has a hot fix, but 8.5 is way too old for Windows 7.
0
 
mlmccCommented:
Also you don't need both 2 and 3.  2 is a superset of 3 and may require additional licensing.  I would just use 3 since it has the features you need.

mlmcc
0
 
Nitin ShahAuthor Commented:
can it work with crystal  8.5?
0
 
JayConverseCommented:
As I said before, Crystal 8.5 is way too old for Windows 7.
0
 
mlmccCommented:
I read in one of these threads that Win 7 doesn't support MAPI mail which is the only mail that CR8.5 does support.  

I would tend to agree that CR8.5 may also have problems on Win7.

mlmcc
0
 
mlmccCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0
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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now