Solved

Exporting to MS Exchange in ActiveX Viewer (WEB ACCESS)

Posted on 2001-09-05
13
324 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:Kriscott
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Force accepting DRRYAN3 comment

Tuvok,
Moderator @ Experts Exchange
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

772 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

10 Experts available now in Live!

Get 1:1 Help Now