Wm.Cowley

 
telephone: 714.324.8046
fax: 714.892.1774
email:

 

Consulting for ERP / MRP, Materials Management, Manufacturing systems Integration, Performance Improvements & Goal Achievement

 

 

 

Up

Crystal Report Viewer Review

When upgrading my clients to Expandable 8.1.2 (and beyond), I often run into a mixed deployment of Crystal 8.5, Compiled Crystal 8.5 (Viewer7), and Crystal 10 reports. The result is many conflicts, and licensing is tedious to manage and remain compliant.

In this article, I’ve assembled some important facts about Crystal and the functionality between the various versions. I’ve also researched and reviewed six Crystal Reports Viewers that you may want to consider deploying at your installation.

  1. You cannot compile reports higher than Crystal 8.5.
  2. You cannot view Crystal 10 reports saved in “Crystal” format without Crystal 10 installed.
  3. With the report manager tool, you can embed reports within Expandable.  These can be run by anyone with a login to ESI and permissions for the report. This option is not cost effective for users outside of ESI like Sales, Inside Sales, & Marketing.
  4. If you do not convert all of your reports to Crystal 10, you must manage and segregate the different versions of the reports. It’s conceivable that you have a compiled version of a report, an uncompiled version and the exact same report upgraded and embedded into Expandable.  A single report change requires replicating the change to all reports.
  5. The cost for the standard version of Crystal reports is $174 (good for viewing and creating reports).  Profession version is $450 (more extensive database capabilities).  Developer edition is $579 and allows for VB programming.  Even the cheapest is too expensive for just viewing reports.
  6. Your company may not have the resources to create your own viewer.

Looking for alternatives, I checked many Crystal user websites.  There are many great sites with good information. My goals for a Crystal report viewer: 

  1. Simple and easy to use.
  2. Inexpensive
  3. Allow running reports (up to Crystal XI)
  4. Allow viewing reports saved in Crystal format.
  5. Eliminate need for Crystal Compiler
  6. Trial version available

With these goals in mind, I researched and reviewed six Crystal Report Viewers. I eliminated one quickly, when I found it only supported up to Crystal 9.  The website may be incorrect or the product was not updated. In either case, I did not want to look closer. 

The five remaining were diverse in terms of licensing costs (A free Adware supported version, Single user $25 to $50, 100 users for $3000 + maintenance) and features (Report scheduler, Batch processing, Shredder, Export and printing options, etc…). All of them met my goals. “Simple” and “Easy to Use” are subjective in nature.  While I want my report writer to have every option and feature, I want the viewer with few options (non-geeky) for the user and allows for “Set it and forget it” configuration.

Company  

Rank

Product

url (Click to view website)

EasyStreetSoftware

2

Crystal Report Viewer

http://www.easystreetsoftware.net

Jeff-Net

3

Report Runner Viewer

http://www.jeff-net.com/

Mind Connection

1

cView

http://www.mindconnection.com

Surfing Gecko Software

4

Crystal Ease 3.0

http://www.surfinggeckosoftware.com

Tatum Consulting

5

CRW Reporting

http://www.tatumconsulting.com

 

 

 

 

 Conclusion:

There were no “Losers” but I had my favorite. Mind Connection’s “cView” product ranked highest. It has a very simple interface and I was impressed with Support.  I had emailed them late Friday night to request a Trial License extension.  My trial license expired and I wanted  to include screenshots in this review.  I quickly received a response telling me it was Saturday in New Zealand and I should hear from them by Monday.  But, within an hour I had received the license extension. This was very rapid response for a Trial License.

 Rollout Plan: 

  1. Further testing or pilot users review (if required)
  2. Purchase licenses & maintenance.
  3. Identify users for Viewer
  4. Identify users for Crystal 8.5 (compare to licenses)
  5. Identify users for Crystal 10 (compare to licenses)
  6. Install viewers.

 …wc

 EasyStreetSoftware, Crystal Report Viewer 

Rank:

2

Installation

Easy with auto-update

View Saved report:

No problems

Run Sample1 V10 report

No problems

Run Sample2 V10 report

No problems

Export to Excel

No problems

Export to PDF

No problems

Can save password?

Yes

Highest Crystal Version

XI

Notes

Built in Report scheduler

 

Display by History or folder.

 

Busy Screen

 

Simple to use

Cost

$35 (1 user)

$29 (21+ users)

 

 


 

Jeff-Net, Report Runner Viewer 

Rank:

3

Installation:

Easy with auto-update

View Saved report:

OK – Needed password to view

Run Sample1 V10 report

No problems

Run Sample2 V10 report

No problems

Export to Excel

No problems

Export to PDF

No problems

Can save password?

Yes – if no password entered, the report will fail. No popup prompt.

Highest Crystal Version

XI

Notes

Report scheduler is a separate product

 

Ad supported Free Version available. Needs fulltime internet connection and shows ads in the header of program screens and reports.

 

Updating Parameters is clumsy. (?)

 

Can review and modify record selection on the fly.

 

No History / Recent rpt listing.  Only directory list.

Cost

$50 (1 user)

$3000 (100 user site license)

+ $2/year/user Maintenance

 

 

Report output:

 

Free Ad Supported version:

 

Both program screen and report output show ads in headers.  However, printed reports do not include the advertisements.

 

 

 

Mind Connection, cView

 

Rank:

1

Installation:

Easy

View Saved report:

Confusing ODBC – Password setup (Menu option

Run Sample1 V10 report

No problems

Run Sample2 V10 report

No problems

Export to Excel

No problems

Export to PDF

No problems

Can save password?

Yes

Highest Crystal Version

XI

Notes

No Report scheduler

 

Display by History or folder.

 

Simple Screen

 

Can review and modify record selection on the fly.

 

Good Support.  Replied Friday after hours from New Zealand to extend Trial license.

Cost

$145 (3 users)

$2499 (100 users)

+$499 /year Site Maintenance (includes updates)

 

 

 

All .rpt files become associated with the hairy eyeball icon.  Some users find it creepy…

 

 

Surfing Gecko Software, Crystal Ease

 

Rank:

4

Installation:

Unzip and manual install.  No auto-update.

View Saved report:

No problems

Run Sample1 V10 report

No problems

Run Sample2 V10 report

No problems

Export to Excel

No problems

Export to PDF

No problems

Can save password?

No

Highest Crystal Version

XI

Notes

No Report scheduler

 

Lots of documentation

 

Report shredder option.

 

Geeky interface.  Lots of Icons. Lots of options.

 

Must use Deluxe Version.  Standard version allows no printing, no exporting, hence NOGO.

 

‘Save As’ to rpt offers Crystal 9 option only

 

Support – No response (within 1 week) from request to extend trial license.

Cost

$199 (10users)

$349 (Unlimited)

  

 

Toolbar Option setup:

 

 

Report output sample:

 

 

Browse for reports window:

 

 

Report Shredder option

 

 

Tatum Consulting, CRW Reporting 

Rank:

5

Installation:

Easy but needs default report location. Cumbersome with many locations available.

View Saved report:

View OK but prompts to refresh data – Bad Idea for saved reports.  Requires folder rights to prevent changes.

Run Sample1 V10 report

No problems

Run Sample2 V10 report

No problems

Export to Excel

No problems

Export to PDF

No problems

Can save password?

Yes

Highest Crystal Version

XI

Notes

No double click to run

 

 

 

 

Costs

Professional Version with security and report groups:

$30 (1 user) - $225 (10 users)

Standard Version

$25 (1 user) - $175 (10 users)

 

 

 

 

 

 

Help File