|
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.
- You cannot compile reports higher than
Crystal 8.5.
- You cannot view Crystal 10 reports saved
in “Crystal” format without Crystal 10 installed.
- 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.
- 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.
- 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.
- 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:
- Simple and easy to use.
- Inexpensive
- Allow running reports (up to Crystal XI)
- Allow viewing reports saved in Crystal
format.
- Eliminate need for Crystal Compiler
- 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.
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:
- Further testing or pilot users review (if
required)
- Purchase licenses & maintenance.
- Identify users for Viewer
- Identify users for Crystal 8.5 (compare
to licenses)
- Identify users for Crystal 10 (compare to
licenses)
- 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

|