Improve company productivity with a Business Account.Sign Up

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

Exporting to MS Exchange in ActiveX Viewer (WEB ACCESS)

I am using IIS 5.0 Win2K w/ service pack 2.
I have Crystal Report 8.5 Running on ASP.  I am trying to export the report to MS Exchange.  I have the samples from Crystal Decesions but all it does is saving the report to disk first then It would ask me if I want to open up the word or excel or crystal report, etc.  Then from the applications I could export to ms Exchange.   That is two step.  According to Crytal's "Destinationtype" I could export to Ms Exchange directly by specifying Destination type = 4(Ms Exchange).  That does not work.  Has anyone done this before?  Is It possible?  If anyone could supply an actual working sample I would be really greatful.  Thank you.
0
Kriscott
Asked:
Kriscott
  • 8
  • 4
1 Solution
 
DRRYAN3Commented:
Kriscott

See http://support.crystaldecisions.com/kbase/c2000103.asp.

According to my documentation, export to Exchange is destination type 6, not 4.  Are you trying to export to an exchange folder, or send a file via MAPI?  If you are trying to export to Exchange, what are you using as a messaging profile on a web server?

DRRYAN3

PS:  Please visit your question history at http://www.experts-exchange.com/jsp/memberProfile.jsp?mbr=Kriscott&showQHistory=true where you will find most of your past questions remain open.
0
 
KriscottAuthor Commented:
Correction....  I am trying to export to Microsoft Mail MAPI, so DestinationType would be 2 I supoose.

CRExportDestinationType
Constant  Value  
crEDTApplication = 5
 
crEDTDiskFile = 1
 
crEDTEMailMAPI = 2
 
crEDTEMailVIM = 3
 
crEDTLotusDomino = 6
 
crEDTMicrosoftExchange = 4
 
crEDTNoDestination = 0
 


0
 
DRRYAN3Commented:
Do you have a MAPI provider configured on your server?  I'm not sure about version 8.5, but in 7 and 8.0 the software app (like Outlook Express) had to be open on the machine where the export was being performed.

DRRYAN3
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
KriscottAuthor Commented:
I don't know what you exactly mean by having MAPI provider configured on my server but all I know is I have to have outlook or outlook express open in order for me to export to Mail.  That's the bug in Crystal Report.
0
 
DRRYAN3Commented:
Outlook/Outlook Express are your MAPI providers.  This is a known issue with Crystal Reports.  See http://support.crystaldecisions.com/kbase/c2006530.asp for CrystalDecisions explanation.

DRRYAN3
0
 
DRRYAN3Commented:
Outlook/Outlook Express are your MAPI providers.  This is a known issue with Crystal Reports.  See http://support.crystaldecisions.com/kbase/c2006530.asp for CrystalDecisions explanation.

DRRYAN3
0
 
KriscottAuthor Commented:
So, where do I go from here?  I Always have a outlook open when I try to export.  I am using one of the sample I downloaded from Crystal's web site.  Aspxmps85.exe is the name of the sameple package.  The actual asp export example I am using is called "SimpleExportReport.asp"
0
 
DRRYAN3Commented:
I'll take a look at it.  Maybe there is something you could do with the CDONTs package from MS.

DRRYAN3
0
 
DRRYAN3Commented:
OK, I looked at the sample you are basing your work from.  This is no different than if you were to run the report from Visual Basic using the RDC and select to export to MAPI.  The MAPI provider would have to open on the workstation in order to send the mail.  If it is not open, you will get various errors about not being able to determine the messaging profile to use.

Even though your report is being accessed via the web, the processing still takes place on the server.  See the comments in the example about suppressing parameter prompting and error messages.

What you can do is to use your ASP code to create a file in the appropriate format (Excel, PDF, RTF) and use an ASP based mailer to send that file to the recipients.  Microsoft has one called CDONTS (I think its free, otherwise noone would use it).  Otherwise, you can buy components to provide this functionality or write your own.

Unfortunately, writing ASP code to do this is beyond my scope of knowledge (and time today).

DRRYAN3
0
 
KriscottAuthor Commented:
Well, thanks for all your comment.  I do have some experience dealing with CDONT.  I will see about that option see if it is suitable for my needs.
0
 
DRRYAN3Commented:
This question has been open for some time now.  Please return and either
1.  Accept an answer
2.  Post a comment stating that you need more information
3.  Ask Community Support to delete the question if you feel the information here has no value to you or anyone else.
4.  Ask Community Support to PAQ the question because your question was not answered but you feel the information here may be of some value to others.

Community Support is here:  http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt and you can leave a message by posting a zero point question.  Be sure to reference the question ID, found in the Address bar of your browser.

Thanks
DRRYAN3
0
 
DRRYAN3Commented:
This question has been recommended for closure at http://www.experts-exchange.com/jsp/qManageQuestion.jsp?ta=commspt&qid=20277616.

Points to DRRYAN3

DRRYAN3
0
 
TuvokCommented:
Force accepting DRRYAN3 comment

Tuvok,
Moderator @ Experts Exchange
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: 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.

  • 8
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now