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      .
LVL 1
nani11Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.

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.