Email crystal reports from clarion 6.3

Posted on 2009-07-15
Medium Priority
Last Modified: 2012-06-27
Im using clarion 6.3 and crystal reports.

My client generates a report ex. of 300 pages. Certain pages are for a different students.

I can export the report no problem but now its one pdf file. how do I "extract" certain pages for certain students and mail just those certain pages to the correct students?

Question by:dudcom
LVL 31

Accepted Solution

RiteshShah earned 672 total points
ID: 24857574
there is no native functionality for doing this. you have to generate PDF for only selected student and send it to concern person. or/else you have to manually separate the pages and send it in email.
LVL 17

Assisted Solution

MIKE earned 664 total points
ID: 24860812
This would entail your report knowing ahead of time which students to run the report for, exlusively so as to email them.

Probably a better use of this type of report is to have it in an Enterprise WEB accessible area where students can come and run for themselves and then have it emailed to themselves.

It can be done, but NOT within Crystal itself.

Also, SQL Server and many other database programs have emailing capabilities, if this is a must requirement I'd check into your database vendor to see if this can be handled there. However to run a single report for multiple students AND ask the report to email each student...is really NOT a function that Crystal was designed for...by choice since it is a rare requirement.

Bottom line is that I would seek outside of Crystal on this one...if SQL Server is your Database, I'd look there for a solution.

Hope it helps
LVL 23

Assisted Solution

by:Ido Millet
Ido Millet earned 664 total points
ID: 24861374
This is called report "bursting" and at least one of the 3rd-party Crystal report managers listed at http://www.kenhamady.com/bookmarks.html can do exactly that.  It dynamically burst the report so that each student becomes a separate export/email using dynamic information in the report to name the export file, email the result, etc.
LVL 101

Expert Comment

ID: 24861555
I agree.  A third-party solution is probably the easiest.


Author Comment

ID: 24892952
Thanks for the reply guys, will se if I can make that 3rd party work for me :)

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

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

How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

624 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