Solved

Combining multiple reports into one

Posted on 2008-11-03
11
2,137 Views
Last Modified: 2013-11-08
I am trying to find a solution for the following probem :

I have multiple crystal reports that are run individually, each report having the same two paramaters passed into them.  
I want to be able to give users the ability to create a "report set (or pack)", selecting 1 or more of these individual reports, to print them as one report, instead of printing individual reports that are required for each job for example.  
Currently I have a report launch c# application that passes the param into the indivdual reports, so I would like a solution that would allow me to combine the reports, defined in the report pack, and if possible allow for page numbering to run true within the report set.

Any help/advce wout be greatly appricieated

TIA
0
Comment
Question by:manney_mcvicker
  • 3
  • 3
  • 3
  • +1
11 Comments
 
LVL 17

Expert Comment

by:MIKE
ID: 22868088
Would combining them into ONE main report..having them be SUBREPORTS work for you?

This would depend on what the reports look like.

Also,...can you schedule the report to print at a scheduled time each day then just have them ready to DISPLAYwhenever a user wants to see them..??
0
 

Author Comment

by:manney_mcvicker
ID: 22868137
Scheduling reports in this instance would not work.
I have thought about sub-reports, but I presume I would somehow need to dynamically add sub-reports with the contents of the individual reports, do you know if this is achievable through the report launcher application?
0
 
LVL 17

Expert Comment

by:MIKE
ID: 22868178
Ok...so you are NOT using an "Enterprise Version" of Crystal Reports, like Crystal Server, or Business Objects XI...right?

I think your best course would be SUBREPORTS...but again...the final format of each report would determine IF this would work. For instance, IF one of these subs is actually a long listing of detail...then it may not look good. I guess you could place the LONGER reports at the end of the SECTIONS that you are using. Seems like it should work.  THen just pass the parameters down to each SUB.

0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 22

Expert Comment

by:Ido Millet
ID: 22869481
You can conditionally suppress subreports (or main report sections that contain the subreports) based on a multi-value parameter that allows the user to select which reports (subreports really) to include.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22869606
That is a a good idea.

WIll the users always want them in a standard order?
If so the idea of a main report with all the others as subreports will work with suppression.
You will then be able to specify R1, R2, R5, R6
Report 1
Report 2
Report 5
Report 6

If you need to do them in varying order then you can modify your application to print multiple reports and retrieve the number of pages and pass it in to the next report to set the start page number.

mlmcc
0
 

Author Comment

by:manney_mcvicker
ID: 22874682
The idea of having 1 report with a different section with a sub report in it is the way  to go with this, but our application currently has approx 220 reports.
I think it would be unadvisable to create 1 report with 200+ sections that are suppressed as required. If only from a maintainablilty stand point!

I would like to be able to have a basic report template, then programaticly add sections to the base report, that would contain a sub report that would contain a rpt file from the report set definedby the user, then add another section ..... and so on.

Is this achievable progmatically through .net?  Can you create sections & subreports progmatically? I have not come across any examples myself.
0
 
LVL 22

Accepted Solution

by:
Ido Millet earned 100 total points
ID: 22875886
This may be doable in .NET but I haven't done or seen anything like it.  Look at the RAS API.

If you are willing to deliver the end result to the user as a pdf, there is a simpler alternative.  One of the 3rd-party Report Managers listed at http://www.kenhamady.com/bookmarks.html has an api that allows you to request report exports to pdf, merging of the pdf's, adding bookmarks (so the user can navigate between the embedded reports), adding a Table of Contents, adding page numbers, etc.
You would simply call the api once for each report and then call the merge and other directives in the last command line.  

One advantage of that approach is that it support cases where some of your reports already contain subreports...
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22890552
I agree with that many reports it is not really doable that way.  Also 220 may be too many for Crystal to handle.

I think IdoMillet's idea is really the only usable solution.

mlmcc
0
 
LVL 17

Expert Comment

by:MIKE
ID: 22890599
Agree,..I've never attempted to load multiple reports into a SINGLE report like this...myself..
0
 

Author Comment

by:manney_mcvicker
ID: 23002680
Cheers peeps for all your input.

IdoMillet's propsal of exporting the indivual reports as pdf's then using third party pdf tools to merge them into a combined pdf, seems a far more logical approach to the problem.  There seem to be quite a few tool sets out there, plenty of free open source ones too, so i'm off to do some more research, and will keep you posted, with whatever solution I end up running with :-)

Thanks again
0
 
LVL 22

Expert Comment

by:Ido Millet
ID: 23003769
The thirdt party tool I was hinting about is not just a pdf tool.  It is a Crystal Report Manager that also has pdf processing functionality.  The advantage for you is that it can automate the whole process (exporting the reports, post-export pdf processing, emailing the merged pdf file, etc.) rather than just the pdf part.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

792 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