Split the Report Output

I have a report which is sectioned by 'department'. And the output will be a pdf. So within the PDF Finance dept has 3 pages, Law has 2 pages and etc. So what I need is I need to split the report and send it to the user's email.

Splitting the report refers that the Finance part of the pdf should have 'Finance.pdf' created and  emailed to Finance dept users and similarly Law should get 'Law.pdf' emailed to Law dept users.

Is there any way to achieve this? Do we have to use macros and SDK stuff to do this?
I know of a few tools like APOS which does this. But those are expensive      .
Who is Participating?
Ido MilletConnect With a Mentor Professor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
There is at least one relatively inexpensive ($300) Crystal report manager among those listed at http://www.kenhamady.com/bookmarks.html that provides exactly that type of bursting functionality.
Can you create 3 reports using selection criteria as department. Then you can use any automation tool like "Autoit" to export report to pdf and email / save in a folder periodically.
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.

All Courses

From novice to tech pro — start learning today.