Crystal Report split in several pdf files based on group - page brake

Hi I need to split a Crystal report  ver. crystal report 2011  in several PDF files based on Group – page brake.
Grouping is based on Client ID,  and one Client records could be on  several pages. I need  to export this report to pdf format so each client gets his separate file .
I assume that this is not possible to be done in crystal report (not server version), Is it possible to do it through VBA – ms -access .
 I can not afford to buy some expensive third party tool.
TarasAsked:
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.

Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
This is called report bursting.  Some of the 3rd-party Crystal Reports Desktop Schedulers listed at http://kenhamady.com/bookmarks.html provide that functionality.

You mentioned "expensive" 3rd-party tools.  Some of the tools that provide bursting functionality cost ~$300.
0
mlmccCommented:
Agree.  It takes an application of some type to do what you want.

If you are good at programming you could also write it out.

The basic method you could use would be

Query to get the list of client ids or set the list yourself
Loop through the list
   Run the report using each element in turn to filter the records
     (you may have to modify the report to add a filter on the client id)
   Export the report to a properly named PDF
End LOOP

mlmcc
0
TarasAuthor Commented:
I would appreciate  one example in VBA??
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

mlmccCommented:
What version of Crystal are you using?

mlmcc
0
mlmccCommented:
Are you running the reports through VBA now?
If so what code are you using?

mlmcc
0
TarasAuthor Commented:
I am using CR 2011 and 2008 both of them.

I am not running report through VBA now.
It is stand-alone report created in CR 2011. I have good understanding of VBA I was thinking of creating simple access form with several boxes : one of them to select Crystal Report with path to it.
 Second to select   Grouping (G1 or G2 for braking reports in files it could be check boxes) and third boxes to select destination folder and command button “Export To Pdf”
0
vastoCommented:
If bursting was easy you were going to find tons of examples online (as you found how to run crystal reports). Also, all of the tools in the list provided by IdoMillet above, were going to support it. This obviously is not the case. It is up to you , which way you will go , but I cannot see any point to write something like this by yourself.
0
mlmccCommented:
CR2008 and CR2011 are strictly .Net programming.  I don't believe they can be called from VBA.  I know there is no support for VB6.

mlmcc
0
TarasAuthor Commented:
mlmcc.
I have visual studio 2010.
I can try to play with Net code.
If you do not have example of  VB code,  vb.net could help.
0
TarasAuthor Commented:
vasto, thanks for support and encouragement!:-)
0
vastoCommented:
Taras, I do not want to offend you . I developed one of the tools in the list above. Ido developed another one. We both know very well how the process works. I don't know about Ido , but I cannot share any code because it is a property of the company where I was working. If there are some independent developers, they might share some code, but  I do not believe this will happen. As I said I would not write the code again. The price of one of these tools ($300) is about the cost of  2-3 hours developers' work. There is no way to write and test anything valuable for 2-3 hours, so I will just find a budget and buy an existing tool.
0
TarasAuthor Commented:
vasto.
I understand your point and I agree that those tools are result of hard work, lot of hours spent on it and very good skills employed by developers.
 I know how much those tools cost and that nothing is free today.
Nobody serious is coming here and expecting to get complete code for free for a tool that is sold for $300 on market.
However I do not need all features and all options that those tools provide for different situations and scenarios.
I was asking for an example of code part which could split an existing Crystal Report in several pdf files by group and nothing else.

How we will go in learning and developing ourselves if all line of written code are locked and not available for us that want to learn new staff.
What is the purpose of this site? To buy or to learn?

There is not line of code today that exists that was not used for something else or not part of some application or tools or that is not proprietary module owned by somebody.
I am not offended.
You have right on your own opinion and attitude. If I am skillful as you and If I have same knowledge as you have, probably I would be reacting like you.

So now I do not know is it better or worse for me to be as I am?
Good luck with your tool.
Regards.:-)
0
mlmccCommented:
Take a look at the code provided by eric moreau in his blog.  He shows how to call a report while passing the data from a recordset in a .Net application.  It includes code for exporting.

You should be able to adapt that code by putting a loop around it and walking through a list of municipalities to generate the pdfs.

http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx

mlmcc
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
vastoCommented:
I am not trying to convince you to purchase anything, I didn't even mention product name (until now). The product, I was working on, has a free community edition , which supports bursting. So if the budget is the problem and you do not need technical support you can get it from here: http://www.r-tag.com/Pages/CommunityEdition.aspx.
0
TarasAuthor Commented:
Thanks a lot
0
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
Crystal Reports

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.