Link to home
Create AccountLog in
Crystal Reports

Crystal Reports

--

Questions

--

Followers

Top Experts

Avatar of J C
J C🇺🇸

Crystal OR SSRS 2008: Is there a way to pull multiple reports into one
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!

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of Guy Hengel [angelIII / a3]Guy Hengel [angelIII / a3]🇱🇺

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

Avatar of J CJ C🇺🇸

ASKER

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.

ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]Guy Hengel [angelIII / a3]🇱🇺

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account

Avatar of vastovasto🇺🇸

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.

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


Avatar of Ido MilletIdo Millet🇺🇸

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.

Avatar of ValentinoVValentinoV🇧🇪

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.

Avatar of vastovasto🇺🇸

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.

Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of J CJ C🇺🇸

ASKER

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.

Avatar of ValentinoVValentinoV🇧🇪

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)
Crystal Reports

Crystal Reports

--

Questions

--

Followers

Top Experts

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.