Solved

Split the Report Output

Posted on 2009-07-16
3
299 Views
Last Modified: 2013-11-15

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
Comment
Question by:nani11
3 Comments
 
LVL 5

Expert Comment

by:dhobale
ID: 24871634
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
 
LVL 22

Accepted Solution

by:
Ido Millet earned 500 total points
ID: 24872656
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now