Solved

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

Posted on 2013-01-07
9
632 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
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
 
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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
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…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

831 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