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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 306
  • Last Modified:

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      .
0
nani11
Asked:
nani11
1 Solution
 
dhobaleCommented:
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.
0
 
Ido MilletProfessor 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.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now