Solved

Exporting to MS Exchange in ActiveX Viewer (WEB ACCESS)

Posted on 2001-09-05
13
325 Views
Last Modified: 2008-03-10
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
Comment
Question by:Kriscott
  • 8
  • 4
13 Comments
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6458672
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
 

Author Comment

by:Kriscott
ID: 6461378
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
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6461412
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
 

Author Comment

by:Kriscott
ID: 6461793
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
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6461829
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
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6461830
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:Kriscott
ID: 6462398
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
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6462615
I'll take a look at it.  Maybe there is something you could do with the CDONTs package from MS.

DRRYAN3
0
 
LVL 12

Accepted Solution

by:
DRRYAN3 earned 300 total points
ID: 6462646
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
 

Author Comment

by:Kriscott
ID: 6465415
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
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6537572
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
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6870544
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
 

Expert Comment

by:Tuvok
ID: 6870736
Force accepting DRRYAN3 comment

Tuvok,
Moderator @ Experts Exchange
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now