Crystal Reports on the Web

January 27, 2017

There are many ways to deploy Crystal Reports to users. I normally lean toward the simpler and less expensive options, like locally installed viewers or scheduled Email delivery. But there are environments where a web based option is necessary. The ‘official’ options from SAP are Crystal Reports Server and BO Enterprise. I have included CR Server in my review to help people make a comparison.  But there are other products out there that many users never see. These are third party products which cost much less.  The list includes:

1) Crystal Reports Server – the official SAP Web portal for small scale deployment
2) Report Runner Web Portal – a traditional Web portal
3) IntelliFront BI– a traditional Web portal
4) Ripplestone– a traditional Web portal
5) RVweb – a traditional Web portal
6) rePORTAL – a traditional Web portal
7) ReCrystallize Pro – a Web launch page generator.
8) ReCrystalize Server – a server-based web viewer
9) Report Launch – a bridge between BO server products and server based applications.
10) RapidStack – a web portal built on BO Enterprise Edge

These products are aimed at several different markets and so they work differently.  Below is a brief rundown on what each product does.  I have also posted a feature matrix (PDF) that shows some of the specifics for comparison, including prices. The terms used in the matrix are defined in this glossary. If you have tried one of these products, or are currently using one, I would love to ask you a few questions.  If you have ever compared two these for an in-house deployment, I would be very interested in your opinions.

Traditional Web Portals:
The first six are more traditional Web portals.  They are similar to BO Enterprise but on a smaller scale.  In these, the user logs into a web-based application from their browser and can choose reports to run, print or export on demand. He is allowed to interact with these reports by refreshing them and changing their parameters. He is also allowed to schedule reports whose output can be delivered to an Email inbox, a web folder or a printer.  They can all be configured so that when the user logs into the web application he sees only reports he has permission to see, based on his privileges. Most can implement “row level security” which means that a generic report can be set to automatically filter the data based on the user running the report.  Authentication can be coordinated with your Windows security or with the security of a web application.  All seven of these provide at least a basic audit trail of user interaction with the product.  The configuration and settings are setup by administrators using a web interface.

1) CR Server by SAP:
CR Server is the original and official method for running reports on demand through a browser.  It covers all the basics, is multi-threaded and adds bursting.  It keeps an instance history and it provides tools to manage the instance archive.  It also provides detailed auditing and a scheduling module.

CR Server is the only tool in this list that does not use the runtime engine to run reports. The runtime engine is limited to processing a maximum of 3 simultaneous report processes, with other requests being queued. CR Server uses the same engine as Business Objects Enterprise which means it can do page-level caching and use unlimited threads to manage load.  CR Server can tap into any number of CPUs as long as you’re on a single server. This server can be physical or virtual without violating the license.

But the price per user is high in the CR Server mixed pricing model.  Most people buy Concurrent Access licenses (CALs).  Five CALs cost $6,600 and allow you to have up to 5 concurrent users.   This means that out of a larger pool of authorized users, any five users can be active on the server at one time.  In addition to CALs you can add specific “Named User” licenses (NULs).  These are for specific people and do not take up a CAL slot, but they are not allowed to be shared with other users. Five NULs cost $2,400.

2) Report Runner Web Portal by Jeff-Net:
This covers all of the features of a traditional web portal mentioned above, except for row-level security.  This tool is multi-thread, but is not really designed to do bursting.   It provides for workflow automation and provides a detailed audit log of user actions.

The vendor provides the ASP source code for the portal.   You can use the latest version of the CR runtime, or (for legacy users) there is a version using the v8.5 runtime.  Jeff-Net also has the most comprehensive support, providing a one-hour response time 24/7/365.

The cost for Report Runner Web Portal is $6,500 per server.

3) IntelliFront BI by ChristianSteven Software:
IntelliFront BI is new this year.  It covers all of the basics of a web portal listed above, except row level security.  It has a multi-threaded engine, provides event based triggers and allows for workflow automation. It also keeps an instance history and provides tools to manage how long the instances are stored.

IntelliFront BI supports Crystal Reports, SSRS reports and Microsoft Power BI reports.  It also supplies proprietary KPI and scorecard functions.

The cost for IntelliFront BI is $50,000 which covers unlimited servers, cores and users.

4) Ripplestone:
This covers all the features of a traditional web portal mentioned above.  It also allows you to include non-reporting documents like PDF, DOC and XLS files within the same security framework.  Note that this tool is not multi-threaded. It does provide a basic instance history – storing copies of previously run reports with their data. It also can ‘Burst’ reports – taking the groups within a report and sending an individual PDF to each group via Email.

The cost for Ripplestone is $3,500 per server.

5) RVweb by Climate 27:
This covers all the features of a traditional web portal mentioned above.   It does instance management including automatically managing how long the archives are kept.  It provides a detailed audit trail of user actions, but does not provide for bursting.  It can also be accessed as a Web service from other sites, providing the report function for other web apps.

Also note that this company is based in the UK, so the prices on their site are in pounds (converted to dollars for the matrix).  The cost is about $2,000 per server.

6) rePORTAL CR by Shahrabani and Associates:
This covers all the features of a traditional web portal mentioned above. It does instance management including automatically managing how long the archives are kept. It provides a detailed audit trail of user actions. It can even ‘Burst’ reports – taking the groups/users within a report and sending an individual instances to each user via email or to another destination. The scheduler includes support for event based scheduling and pre/post schedule database triggers. It can also be implemented on a web farm to distribute load across multiple servers (for high usage environments).

The cost is $3,000 per server. For an additional fee you can manage SQL Server Reporting Services reports in addition to Crystal Reports.

Other Options:

7) ReCrystallize Pro by ReCrystallize.com
This is a relatively inexpensive product compared to the others (hundreds not thousands). It is designed to create web Pages that display the reports with up-to-date, live data in most web browsers – including iPhone, iPad, and Android devices. It does this by walking you through a wizard to collect options and then generating ready-to-run ASP (or ASP.NET)  web pages. The wizard allows you to:

* Set your database user name/password so that it can’t be seen by users.
* Prompt for report parameters at runtime, including dynamically generated lists of values.
* Preset date parameters to use common relative dates (i.e. today, end of last month, etc.).
* Choose a Crystal web viewer or output file format (Active X, Java, PDF, XLS, etc), or allow the user to choose.
* Send the report output as an Email attachment.

These pages can then be tweaked to match the style of your existing web site. You just need to know how to edit ASP or how to use an ASP compatible editor.  The web pages can be called from your own web applications and the code can be modified to integrate with your web applications.

The latest release of ReCrystalize supports all versions of Crystal from CRv9 through CR 2013.

The cost of ReCrystalize is $495 per developer.

8) ReCrystallize Server by ReCrystallize.com
ReCrystalize Server is a server-based web viewer that is designed to be simple to deploy . It allows you to refresh and preview reports, but doesn’t include things like scheduling, audit trails, security levels or bursting.

It does provide web based administration and is multi-threaded. It also allows you to launch reports from a hyperlink and pass in parameters as part of the hyperlinks.

ReCrystalize Server only costs $995 per server.  The optional annual support/maintenance is $500 per year (when purchased with the product).

9) Report Launch by LaunchWorks:
This tool has a more narrow audience. It is designed for people who already have a Business Objects Server product (CR Server or BO Enterprise) and who also have a web based application that can’t launch reports. Report Launch bridges the gap between these two components. It lets you specify pages in your web based application that can serve as launch pages for reports. The alternative would be to build your own interface by writing code that taps into the BO report server SDK. If you don’t want to do that you can use the Report Launch API to do it for you.

ReportLaunch also provides an “instant web portal” front end that can be accessed by most web browsers including Android, Blackberry, and iPad/iPhone devices.

In all cases, features like scheduling reports or user/group security are handled in the BO server product. Report Launch simply exposes these BO application features to your web application.

The cost for ReportLaunch is $3,000 per server.

10) RapidStack by LaunchWorks:
RapidStack is a heavy duty web portal built on a foundation of Business Objects Enterprise (Edge). This means that it can handle Crystal Reports, Webi Reports and Crystal Dashboards (Xcelsius).

It covers all the features of a traditional web portal mentioned above, including instance management and managing how long the archives are kept. It provides a detailed audit trail of user actions. It can even ‘Burst’ reports – taking the groups/users within a report and sending an individual instances to each user via email or to another destination.

A RapidStack license is billed annually. The cost for 5 named users is $3000 per year which includes all maintenance and support. There are other license configurations that combine concurrent and named users.








Leave a Reply

Jeff-Net
Versa Reports

remiCrystal reporting solution