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

x
?
Solved

Exporting to MS Exchange in ActiveX Viewer (WEB ACCESS)

Posted on 2001-09-05
13
Medium Priority
?
335 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: 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.

 

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 1200 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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

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…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Screencast - Getting to Know the Pipeline
Suggested Courses

971 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