phone: (540)338-0194
email: ken@kenhamady.com


Individual Instruction by Ken Hamady

The Crystal Reports Underground News - February 2002
an independent source for Crystal Reports Information
by Ken Hamady, MS


Contents for February:
** Questions to ask while planning a Crystal Reports deployment
** Understanding the Crystal Reports licenses and fees
** Options for deploying Crystal Reports to multiple users
** Winter/Spring classes in Leesburg, Baltimore and Philadelphia
** An even *better* place to buy Crystal on the Web
** Washington DC Area User's Group Meeting in February
** Expert on-site training or consulting
** Finding a stray formula so that it can be deleted
** Compile feature is now only for Developer's Edition
** My Quick Reference to Crystal Reports in Visual Basic
** Read back issues at http://www.kenhamady.com/news.html


Questions to ask while planning a Crystal Reports deployment:

There seems to be some confusion around the options for deploying Crystal Reports.  To understand your options you first have to answer the following questions:

1) How many people need to Design reports (RPT files)?
2) How many people need to Run reports (live data) that are Designed by someone else?
3) How many people need to View the static output of reports run by someone else?
4) How often will the reports be run?
5) Do you need to schedule reports to run at a certain time each day/week/month?
6) Do you need to create custom launch screens by writing an application?
7) Will this application run on a server (network or Internet) or one each local PC?
8) Do you want to control access to reports based on the user's identity?
9) Do you want to distribute report output via Email or Web site?


Understanding the Crystal Reports licenses and fees:

Once you have a handle on the questions above, it helps to become familiar with the terms and fees in the Crystal Licenses:

1) Server applications: 
Using versions 4 through 7 of Crystal, you can use the Web Component Server (WCS) that comes with Crystal Reports, and there are no license limits on how many users can run reports on your server.  But, these versions can only effectively handle a certain number of simultaneous users (5 - 15 by some estimates).  If you upgrade to version 8 of Crystal Reports, you can use either the v8 WCS or Crystal Enterprise.  These can handle higher levels of traffic, but you are limited by license to 5 concurrent (simultaneous) users per application.  Additional concurrent users require additional payments for licenses. 

2) Client applications:
However, there is an often overlooked distinction in the license between applications run on a network and applications run on a local PC.  If you create an application that is installed and runs on each local PC, then there is no limit to the number of people that can be running that application.  From my reading of the license (and seconded by an Authorized Crystal Partner) the location of the report or the data isn't the issue, as long as the application and the "report processing" occurs on the local PC.

3) Applications that require royalties:
Most applications that launch Crystal Reports do not require royalties.  However there are certain commands that go beyond launching reports and changing basic report settings.  If you include these commands in your application, then you have to pay royalties with each copy of the application you distribute.  The files and commands that require royalties are specified in the License.HLP file that comes with the Developer's Edition.  There are no royalties for the reports themselves, just the files that contain these specific application commands.

4) The Crystal Broadcast License (CBL):
You might assume that once you create a report, that you can do whatever you want with the output.  You would be wrong - possibly $10,000 per year wrong.  Starting with v8 the license for Crystal reports puts restrictions on what you can do with your "reports".  A report is defined as anything created with Crystal, so it could be an RPT file, an HTML page or even a text export file (they make a specific exception for hard copy).  So, if you automatically and regularly send a "report" to more than 50 people, that costs $10,000 per year.  Or, if you automatically and regularly post it to the web where more than 50 people are likely to see it, that costs $10,000 per year.  The key here is "automatically and regularly".  For more about this, see the 'fine print' link on my website for the dialogue I had with the license manager at Crystal Decisions.

The CBL does not apply to the 5 concurrent users who are under a server based system license.  This CBL also does not apply to reports distributed with an application because these reports are not re-distributed "automatically and regularly".  Last the CBL does not apply to reports created with v7 of Crystal Reports.

Options for deploying Crystal Reports to multiple users:

Once you answer the initial questions, and understand the fees, you can decide how to deploy Crystal Reports to your users.  All users who need to create the original RPT files (report designers) need to have a copy of the Crystal Reports.   For user's who need to run or view reports created by others, I have listed several options below.  Most of these are not affiliated in any way with Crystal Decisions.  Each of these products has a link on my web site's "Links" page.  These are all of the options I have been able to find, including those offered by my competitors, so please let me know if I have missed an option.

1) Give additional copies of Crystal Reports to all users.
This is a simple solution, but can be expensive.  Another potential downside is that it gives the user the ability to modify the reports, which is not always intended.

2) Download the FREE compiled report viewer function.
Although Crystal Decisions has been trying to steer people away from this option, it remains the number one download on their website.  As of January 2002 it has been changed so that it is only for users who have at least one copy of the Developer Edition (or know someone who does).  I discussed this feature at length in my September newsletter:

newsletter/news0109.html

3) Build your own client "viewer" application in VB.
If you are a programmer you will be amazed at how simple it is to write a "client application" that can view reports.  I have included a working example (source code) in my VB Reference Guide.  The CRv8 Developer Edition (or CRv7 Professional) gives you the license to build, compile and even distribute client applications that have the ability to view Crystal Reports.  If you plan to distribute your application you should  read the license carefully for the few restrictions that might apply.

4) Buy a viewer program. 
There are a couple of programmers that have done what I have described above and sell a ready-to-install viewer that you can use to view reports.  These are generally about $35 - $50 per user, but I am sure that you can negotiate lower prices on volume purchases.  The four that I have listed on my links page are CRW Reporting (the lowest price), CView, ReportX and HammerLaunch.  If you want to add scheduling and/or password security the price is $70 - $500 and you can look at CRW Reporting Pro, CrystalDesk, Cview Manager or ReCrystalize Scheduler. 

5) Crystal Version 7 Web Server (WCS). 
If you are using CRv7 Professional, you can install the Web Component Server on a web server for free.  Reports can be launched from Web pages and can be controlled with commands from the Crystal Automation Server, or from Active Server Pages (programming required).  The v7 WCS can be used by any number of users, with no license limitations.  The practical limit is in the volume that the v7 WCS can handle.  I  have heard that it may start to degrade at anywhere from 5-15 concurrent users, depending on how it is deployed.  You would want to test this configuration in your environment under real-world volumes.  There is also a v8 WCS but it is limited by license to 5 concurrent users.

6) ReCrystalize Web Code Generator.
If you are considering the previous option, there is a piece of software that will generate the programming code for you.  This is a product called ReCrystalize.  It generates the basic pages for either the Automation Server or for ASP.  You can then customize the code if needed.  It starts at $264.

7) Crystal Clear Report Server.
If you want a report-server that you can program in Java, you can take a look at Crystal Clear.  This is a Report Server that you use in place of the Crystal Web Component Server (WCS) mentioned above.  It is completely written in Java, so it is platform independent.  It runs $900 - $1,500 for unlimited users on a single server.  Crystal Clear can be used with all versions of Crystal Reports.  If you are serving Crystal v8 reports, you have to be aware of the CBL fees (mentioned above) and when they start to apply.

8) Parallel Crystal Report Server.
If you want a high volume report-server that can be programmed in both COM and Java,  then take a look at Parallel Crystal.  This is a report server designed for very high volume environments.  It starts at $25,000 for unlimited users on a dual processor server. This can be used with all versions of Crystal Reports.  If you are serving Crystal v8 reports, you have to be aware of the CBL fees (mentioned above) and when they start to apply.

9) If you don't want to do any programming there are 2 products that you can buy that come with a completed front end for your users.  They are Trinity Web and Cizer.  Both allow web based viewing of reports and other office documents.  Both provide security features and scheduling features including Email distribution.  If you are serving Crystal v8 reports, you have to be aware of the CBL fees (mentioned above) and when they start to apply.

Cizer is compatible with Crystal Reports, but this is not mentioned on their web site.  It starts at $8,500 per processor.

Trinity Web allows some customization of the screens and code (written in PHP) and starts at $4,500 for 10 named users.

10) Crystal Decisions offers two products - Seagate Info (for networks) and Crystal Enterprise (for the Internet).          

Study with an Expert this Winter:

Click the "Public Classes" button above for dates.
Each class is $675 per student.
Call for more information at (540) 338-0194.


Smart shopping for Crystal Reports, update:

Last month I mentioned 2 major online software retailers, CDW and PC Connections.  Since then I have found a site that offers even better prices for Crystal Reports, Atomic Park. 

http://www.atomicpark.com/

I haven't ordered from them yet, but they have a BizRate rating of 9.0 based on 5,000 customers.  Here is a new price comparison from 1/19/2002:

8.5 professional, single user boxed:
    Crystal Decisions: $395
    CDW: $356
    PC Connections: $350
    AtomicPark:    $339 with free shipping


Washington DC Area User's Group Meeting this month:

There is a CD User's Group meeting for the DC area on the afternoon of 2/19/2002.  If you are interested, I have posted a copy of my invitation on my web site.  It includes the Email address of the person who handles registration.  Registration is required.

http://www.kenhamady.com/cdug.html


Expert On-Site Training or Consulting:

I have personally taught over 1200 satisfied students in more than 30 states.  On-site training is my specialty, and I charge about half of the "List Price" for Crystal Training. 

Do I know my stuff?  Go to Crystal Reports General forum at Tek-Tips.com and you will find me listed as the top Crystal Reports expert out of over 23,000 members:

    http://www.tek-tips.com/gthreadminder.cfm/lev2/4/lev3/100/pid/149

Can I teach?  Over 1200 students would recommend me.  Ask to speak to a recent customer as a reference.  Call for more information at (540) 338-0194.


Finding a stray formula or parameter:

Crystal will not allow you to delete a formula (or parameter field) from the field list, unless that formula is no longer used anywhere in the report.  Unfortunately, there are several hundred places where a formula could be hiding.  These include sorting, grouping, selecting, totaling and dozens of formatting formulas for every report object.  Checking all of these hiding places is not practical, so here are three ways to have Crystal help you uncover where the field is being used.

One technique is to export the report using the "report definition" format.  This creates a text file that lists (almost) all of the settings used in the report.  Theoretically you can search this text file for your formula name and see all of the uses of the formula.  The export will show if the field is used in a section, or in one of the hundreds of condition formulas available in your reports.

However there are a few bugs in this export.  In a short test I found several places where I could hide a formula field and it would not be picked up by the "report definition" export.  The ones I found in v8.5 are the condition formulas for  "Section Background Color", "Underline" and "Strikeout".  I would be surprised if there weren't others.  If the export doesn't locate the formula, there is another technique.  This requires that you change the data type of the formula.  If it is currently a numeric, change the formula to any character value, even "x".  If it is currently a character formula, change it to any numeric value, even zero.  When you try to preview the report, any condition formula that was using this value will now generate an error, and pop up on the screen.

If neither of these locate the formula, the field is likely sitting on the canvas but out of view.  This happens when the orientation or page size is changed.   Make the page wider or switch to landscape to see if the object is out of view on the canvas.


Changes to the Compile Feature:

Crystal Decisions has recently changed the compile feature that you can download from the Crystal Decisions web site.  Until late last year the download would install with Crystal Reports v8 Professional or Developer.  Now there is a message that says it is "only for use with the Developer edition".  It is unclear what happens to everyone who downloaded the earlier version of the file for use with Professional.  It was one of there most popular downloads.


VB Quick Reference Guide:

If you plan on incorporating Crystal Reports into a VB application, you should get my Quick Reference Guide.  It gives an overview of the integration methods, with syntax examples for the most important commands.  It comes with some source code examples, including a sample report viewer.  It is only $16 and can be Emailed to you within 24 hours.  Follow the link below for more details:  

http://www.kenhamady.com/vbref.html


Contact Information:

Ken Hamady, MS
525K East Market St.  PMB 299
Leesburg, VA 20176
(540) 338-0194
ken@kenhamady.com
http://www.kenhamady.com


Copyright 2002 by Ken Hamady
All rights reserved - Republishing this material requires written permission