Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1668
  • 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_s_shah
Asked:
nitin_s_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_s_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
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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

mlmcc
0
 
nitin_s_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_s_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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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