Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Exporting to MS Exchange in ActiveX Viewer (WEB ACCESS)

Posted on 2001-09-05
13
328 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
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.

 

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
 

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

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.

Question has a verified solution.

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

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…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

791 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