Solved

Crystal OR SSRS 2008: Is there a way to pull multiple reports into one

Posted on 2013-01-07
9
607 Views
Last Modified: 2013-01-09
I have multiple reports that I will be building, their purpose is strictly mail merge. It's a contract that consists of multiple documents that I want to merge into a single report/document. Can someone tell me if this is possible and what the best method would be to accomplish this?

Thanks!
0
Comment
Question by:J C
  • 2
  • 2
  • 2
  • +2
9 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38752585
to start with: why into a single report/document?
apart from that, it is possible with both, so the "best" method is "whatever you like"...
0
 

Author Comment

by:J C
ID: 38752602
SSRS is preferred.

The reason is that all of the documents are parts of a whole contract. I want to make it as easy as possible for our staff who hands out these contracts and to be able to have it generated and exported as a single doc would be helpful.
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 38752637
in both Crystal reports and SSRS you can add subreports...
while in Crystal I knew already how to do it, I had to double-check for SSRS:
http://msdn.microsoft.com/en-us/library/dd220581%28v=sql.100%29.aspx
0
 
LVL 18

Expert Comment

by:vasto
ID: 38752731
There is a report scheduler, which can join multiple reports in one document. You can add multiple Crystal reports, SSRS reports and pdf files,  produce a single document and send it by e-mail. The tool provides also a workflow, which will allow you to add a report or pdf file if a condition is satisfied. For example you can add a PDF "Welcome letter" just for the new clients or a report with local offers just for clients in a specific ZIP etc. The tool provides also a WYSIWYG editor for the e-mails, which supports mail-merge .
Check their website for more details: http://www.r-tag.com/Pages/ReportManager.aspx

Disclaimer: I was working for this company in the past.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 22

Expert Comment

by:Ido Millet
ID: 38754449
There is at least one other 3rd-party Crystal Reports desktop scheduler among those listed at http://kenhamady.com/bookmarks.html that can automate the process of merging multiple Crystal reports into a single document.  The merging can be done not only for pdf files but also for MS Word files (which could be relevant for your case where you need to handle contracts).  PDF merging can also take care of generating bookmarls, page numbers, and Table of Contents.
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 38754699
In addition to the previous answers: one limitation of SSRS you may want to take into account is that it's not possible to mix portrait and landscape in PDF exports.  Imagine you'd had a requirement to have the first page, which is a letter, in portrait while all following pages should be in landscape.  That wouldn't be possible without additional tools or custom code.

Besides that, I don't see any issue if you'd go in the "main report with subreports" direction.
0
 
LVL 18

Expert Comment

by:vasto
ID: 38756296
ValentinoV is right - with SSRS you can use subreports and the only problem will be if you need mixed (portrait AND landscape) orientation of the pages. With Crystal report you will have one more problem: this engine doesn't support nested subreports hence your individual reports cannot contains subreports otherwise you will be not able to add them as subreports to your main report. It might sound confusing, but here is an example:
You have 5 reports which you want to export to one file. You can add them as subreports to a new report, which will be used just as a "packager". When you export the "packager" the exported file will contain the result from all 5 reports. If one or more of these 5 reports contain subreports then you will be not able to add it to the "packager" because you will have nested subreports and this is not supported by Crystal. SSRS will be able to handle this scenario without problems.

Using an external tool will allow you to have portrait and landscape pages (in both SSRS and Crystal) and to use reports with subreports in Crystal. I like R-Tag because:  
 * It is written using the latest technology and has 32 and 64 bit versions. No old COM components covered with a new skin
 * Supports both Crystal Reports and SSRS
 * Can control the order and existence of the reports and the static files based on custom conditions
 * Has internal document management, C# compiler and tons of options to customize your export including a WYSIWYG e-mail editor and export to SharePoint
 * It might be helpful in other projects: for example you will be able to use data driven subscriptions even with SSRS Express

However, keep in mind that adding one more item to the chain will require additional time for training and implementation, so ANY 3rd party tool will come with a hidden price.
0
 

Author Comment

by:J C
ID: 38757161
This appears to be quite cumbersome. I have multiple pages that I need per subreport/doc. How do I create "pages" in SSRS? I thought about trying to group but I am not sure what to group on, I know I can create page breaks that way.
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 38757871
SSRS creates pages automatically when you export to a format that supports pages (such as PDF).  It will use the PageSize and Margins report properties while doing so.

Have a look at the following webpage to get a better understanding on how pagination works: Pagination in Reporting Services (Report Builder and SSRS)
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

705 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

15 Experts available now in Live!

Get 1:1 Help Now