Crystal Reports Feature Comparison

by Version and Edition

This comparison matrix provides a checklist of features supported in current and previous versions Crystal Reports leading
up to the present, Version 9. All data is for 32-bit versions only.

Updated: August 2002

Key
A. Advanced D. Developer P. Professional S. Standard
Y. Special Crystal Reports version available in all versions of Microsoft Visual Studio .NET

Report Types New in 9 9 .NET 8.5 8 7 6 5 4.5

Mailing labels A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Cross-tab reports Enhanced A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Form-style reports A, D, P, S Y D, P, S D, P, S P, S P, S P
Subreports A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Conditional reports A, D, P, S Y D, P, S D, P, S P, S P, S P, S
TopN reports A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Drill Down reports A, D, P, S Y D, P, S D, P, S P, S P, S P, S
OLAP reports Enhanced A, D, P D, P, S D, P, S P, S

High Productivity Report Creation New in 9 9 .NET 8.5 8 7 6 5 4.5

Data Explorer Enhanced A, D, P, S Y D, P, S D, P, S
Report Explorer New A, D, P, S
Microsoft Excel and Access Add-ins A, D, P, S D, P, S D, P, S
Report Experts for automatic report creation Enhanced A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Graphical table linking Enhanced A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Field mapping between databases A, D, P, S Y D, P, S D, P, S P, S
Repository for component reuse New A, D, P
Custom Templates New A, D, P, S
Template Window (Design) A, D, P, S D, P, S D, P, S P, S P, S P, S P, S
Fully customizable runtime Preview Window A, D, P, S D, P D, P P P P, S
Drill down in runtime Preview Window A, D, P, S D, P, S D, P, S P, S P, S

Report Viewing and Interaction New in 9 9 .NET 8.5 8 7 6 5 4.5

Parameter prompts via the Web A, D, P D, P
DHTML Report Viewer Enhanced A, D, P Y D, P D, P
ActiveX Report Viewer A, D, P D, P D, P P P
Java Report Viewer Enhanced A, D, P D, P D, P P P
Netscape Viewer plug in A, D, P D, P D, P
Local printing and export from viewer A, D, P D, P D, P P
Page-on-demand A, D, P Y D, P D, P P P
ASP Report Server A, D D D P P
Crystal Enterprise Report Application Server New A, D, P
ePortofilo Lite for on-demand access to
reports via Web New A, D, P
Advanced search on saved data; export
search results to Microsoft Excel,
Word and HTML New A, D, P Y

For more information, visit:

[Link]/crystalreports
[Link]/hyperion

Access. Analyze. Report. [Link]

 Comprehensive Formatting and
Design Control New in 9 9 .NET 8.5 8 7 6 5 4.5
Ability to return to Report Experts A, D, P, S D, P, S D, P, S P, S P, S P, S
Guidelines and vertical rulers A, D, P, S D, P, S D, P, S P, S P, S P, S
Automatic styles, auto-arrange fields, ruler A, D, P, S D, P, S D, P, S P, S P, S P, S P, S
Drag and drop, browse field data A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Drawing-style interface A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Line drawing, box drawing A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Circles, ovals and boxes with
rounded corners A, D, P, S Y D, P, S D, P, S
Moving & resizing objects, selecting
multiple objects A, D, P, S D, P, S D, P, S
Conditional font formatting A, D, P, S Y D, P, S D, P, S
Conditional formatting of text
by style and size A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Vertical text A, D, P, S Y D, P, S D, P, S
Fractional font size A, D, P, S Y D, P, S D, P, S
Format Editor A, D, P, S Y D, P, S D, P, S P, S P, S P, S
BLOB bitmap support A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Graphic image support
(BMP, TIFF, PCX, TGA) A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Graphic image support (JPEG, PICT, PNG) A, D, P, S Y D, P, S D, P, S
Support for vector-based images New A, D, P, S
Grid control options
(on/off; visible/invisible, set line height) A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Charting on subtotals, groups,
details and formulas A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Integrated geographic mapping A, D, P, S D, P, S D, P, S P, S
Integrated charting Enhanced A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Embed Hyperlinks into reports A, D, P, S Y D, P, S D, P, S
Redo and multiple undo A, D, P, S D, P, S D, P, S P, S P, S P, S P, S
Multiple detail sections A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Underlay sections A, D, P, S Y D, P, S D, P, S P, S P, S P, S
OLE 2.0 support A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
OLE drag & drop between windows A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Copy entire report objects to
Windows clipboard A, D, P, S Y D, P, S
Cross-tab objects Enhanced A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Subreport objects A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Text objects A, D, P, S Y D, P, S D, P, S P, S P, S P, S
User-defined ToolTips for tools and
report objects Enhanced A, D, P, S Y D, P, S D, P, S P, S
Running totals expert A, D, P, S Y D, P, S D, P, S P, S
Top N, bottom N sorting A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Custom (named) grouping A, D, P, S Y D, P, S D, P, S P, S
Sort and subtotal in ONE step A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Parameter fields A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Use Basic-like syntax in Formula Language A, D, P, S Y D, P, S D, P, S
Extensible formula language
(supports COM Object) Enhanced A, D, P, S Y D, P, S1 D, P, S1 P, S1 P, S1
Formula Workshop New A, D, P, S
Custom Functions New A, D, P, S
Formula control of formatting A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Display string formatting New A, D, P, S
User-Defined Functions A, D, P, S Y D, P, S1 D, P, S1 P, S1 P, S1 P, S1 P, S1
Year 2000 UFLs A, D, P, S Y D, P, S D, P, S P, S P, S
Select Records intuitive query interface A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Hierarchical group summary A, D, P, S Y D, P, S D, P, S

For more information, visit:

[Link]/crystalreports
[Link]/hyperion

Access. Analyze. Report. [Link]

 Interactive Analysis Tools New in 9 9 .NET 8.5 8 7 6 5 4.5
Report Alerts A, D, P, S D, P, S
Map lens A, D, P, S D, P, S D, P, S
Analyzer view for charts A,D, P, S D, P, S P, S
Integrated Analyzer for charts New A, D, P, S
Include charts in reports Enhanced A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Conditional formatting on charts New A, D, P, S
Include maps in reports A, D, P, S D, P, S D, P, S P, S
Customizable cross-tabs A, D, P, S Y D, P, S D, P, S P, S
Field highlighting Enhanced A, D, P, S D, P, S D, P, S P, S
Formula Editor Enhanced A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Formula Expert New A, D, P, S
Drill-down, full-featured search dialog A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Drill-down level functionality New A, D, P, S Y
Smart Navigation; group tree, drilldown, search A, D, P, S D, P, S D, P, S P, S P, S
Guided Navigation New A, D, P

Efficient Report Distribution and Access New in 9 9 .NET 8.5 8 7 6 5 4.5

Web report deployment A, D, P Y D, P D, P P P
Export to XML A, D, P, S D, P, S
Export to PDF Enhanced A, D, P, S Y D, P, S
Export to DHTML (HTML 4.0) A, D, P, S Y D, P, S D, P, S
Export to HTML A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Export to Microsoft Word, Excel
(data and rich format), Lotus 1-2-3, text Enhanced A, D, P, S Y(XLS) D, P, S D, P, S P, S P, S P, S
RTF export Enhanced A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Export to character-separated values,
paginated text, record style
(columns of values), report definition,
tab-separated text and values A, D, P, S D, P, S D, P, S P, S P, S P, S P, S
Export to disk A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Export to application A, D, P, S Y D, P, S D, P, S P, S
Export to ODBC databases A, D, P, S Y D, P, S D, P, S P P P
Microsoft Mail A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Microsoft Exchange A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Lotus cc:Mail® A, D, P, S D, P, S D, P, S P, S P, S P, S P, S
Lotus Notes® A, D, P, S D, P, S D, P, S
Export and/or e-mail reports with saved data A, D, P, S D, P, S D, P, S P, S P, S P, S P, S
Send reports with saved data for
distributed analysis A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Report options saved with report A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Save subreport as standalone report A, D, P, S D, P, S D, P, S
Report Parts for wireless and portal integration New A, D, P
Guided Navigation between report elements
in same or multiple reports New A, D, P
Support for Microsoft Smart Tags in Office XP New A, D, P, S
Export advanced search results from viewer to
Microsoft Excel, Word and HTML New A, D, P

Other Features New in 9 9 .NET 8.5 8 7 6 5 4.5

Predefined sample reports Enhanced A, D, P, S D, P, S D, P, S P, S P, S P, S
Auto Saving A, D, P, S D, P, S D, P, S

Report Integration Methods New in 9 9 .NET 8.5 8 7 6 5 4.5

Java, .NET and COM Report Viewing SDKs New A, D Y(.NET)
Java, .NET and COM Report Creation and
Modification SDKs (Report Application Server) New A Y(.NET)
Embeddable Crystal Reports Designer Control A, D D
Report Designer Component A, D D D P
Crystal Report Print Engine API A, D D D P P P P
For more information, visit:
[Link]/crystalreports
[Link]/hyperion

Access. Analyze. Report. [Link]

 Rapid Application Development New in 9 9 .NET 8.5 8 7 6 5 4.5
Multi-pass reporting with powerful grouping
and sorting A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Sorting on groups, unlimited sorting A, D, P, S Y D, P, S D, P, S P, S P, S P, S
Heterogeneous data sources A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Top N, specified groups A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Support Microsoft Visual Basic 6.0 features A, D D D P
Report Creation APIs
(additional license required) A, D D D
Support for Unbound fields with auto binding A, D D D
Customizable Report Viewer Window A, D Y D D P P P P
Active Data Driver Support (ADO, RDO, CDO)
for runtime data sources A, D Y ([Link]) D D P P
Event/call-back support A, D Y D D P P
Drill down in runtime Preview Window A, D Y D D P P
Fully customizable runtime Preview Window A, D Y D D P P

Other SQL Features and Tools New in 9 9 .NET 8.5 8 7 6 5 4.5

Support for SelectDistinct for selecting records A, D, P, S Y D, P D, P
Support for TopN for selecting records A, D, P, S Y D, P D, P
SQL database access A, D, P, S Y D, P D, P P
SQL pass-through A, D, P, S Y D, P D, P P P P P
Ad hoc SQL query tool D, P D, P P P P P
Unlimited SQL Commands New A, D, P, S
Sort data on SQL database servers A, D, P, S Y D, P D, P P P P P
Security pass-through A, D, P, S D, P D, P P P P P
Database driver conversion A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S
Group-by, aggregation and SQL expressions
on SQL database servers A, D, P, S Y D, P D, P P
Stored Procedure Support (Access via ODBC,
Oracle 7.2, Sybase, SQL Server, Watcom/
SQL Anywhere) A, D, P, S Y D, P, S2 D, P, S2 P P P P

Native PC Database and File Access New in 9 9 .NET 8.5 8 7 6 5 4.5

Act!TM A, D, P, S D, P, S D, P, S P, S P, S P, S P, S
Pervasive (all indices, requires DDFs) A, D, P D, P, S D, P, S P, S P, S P, S P, S
FoxPro® 2.6 (IDX, CDX) A, D, P, S D, P, S D, P, S P, S P, S P, S P, S
Microsoft Access A, D, P, S Y D, P, S D, P, S
Microsoft Exchange A, D, P D, P, S
Microsoft Outlook A, D, P, S D, P, S D, P, S P, S P, S
Paradox 3.5-4.5 (Native) 3.5-7.0 (BDE) A, D, P, S D, P, S D, P, S P, S P, S P, S P, S
File system A, D, P, S D, P, S D, P, S P

Native Client/Server and Network Data Access New in 9 9 .NET 8.5 8 7 6 5 4.5
Multi-threaded DB access
(OLE DB & native drivers) A, D, P Y D, P, S D, P, S
Oracle® 7.x A, D, P D, P D, P P P P
Oracle 8.x A, D, P D, P D, P P
Oracle 9i New A, D, P
IBM® DB2®, DB2/2, DB2/400, DB2/600 A, D, P D, P D, P P P
Informix A, D, P D, P D, P P P
Lotus Notes & Domino 4.5 and above, R5 A, D, P D, P D, P P
Microsoft Exchange A, D, P D, P D, P P P P
Microsoft Internet Information Server A, D, P D, P D, P P P P
Microsoft System Management Server A, D, P D, P D, P P P P
Microsoft Windows NT® Event Logs A, D, P D, P D, P P P P P
Web server activity logs (NCSA format) A, D, P D, P D, P P P P
OLE DB A, D, P Y D, P, S3 D, P, S3 P
Sybase SQL Server 10, 11 A, D, P D, P D, P P P P
Hyperion Essbase® A, D, P D, P D, P P P
For more information, visit:
[Link]/crystalreports
[Link]/hyperion

Access. Analyze. Report. [Link]

OLAP Data Sources New in 9 9 .NET 8.5 8 7 6 5 4.5
Essbase 5.0.2, 6.0.0, 6.1.0 A, D, P D, P, S D, P P
IBM DB2 OLAP 7.1 A, D, P D, P, S D, P P About Crystal Decisions
Crystal Decisions is an information
Crystal Holos 8.0, 8.5 New A, D, P
management company and market
HDC Cubes A, D, P D, P, S D, P P leader in reporting, analysis, and
MS OLAP (Analysis 2000) New A, D, P information delivery. Our solutions
MS SQL Server 7 OLAP Services A, D, P D, P, S D, P help customers make better business
decisions by bringing together
ODBC Data Source New in 9 9 .NET 8.5 8 7 6 5 4.5 people and information. The
XML A, D, P D, P, S company’s world-class solutions are
used by millions of customers in
ASCII A, D, P, S D, P, S D, P, S P, S P, S P, S P, S
thousands of companies worldwide
DBase A, D, P D, P D, P P P P, S P, S
and include Crystal Enterprise,
IBM DB/2 (DDSC only) A, D, P D, P D, P P P Crystal Reports, Crystal Analysis and
Informix (Inet 5, 7) A, D, P D, P D, P P P P Crystal Applications. Expert technical
Microsoft Access A, D, P, S D, P, S D, P, S P, S P, S P, S P, S support, consulting, training and
eLearning services ensure maximum
Microsoft Access Queries A, D, P, S D, P, S D, P, S P, S P, S P, S P, S
return on investment. Crystal
Microsoft Excel A, D, P, S D, P, S D, P, S P, S P, S P, S P, S Decisions can be found around the
Microsoft FoxPro A, D, P, S D, P, S D, P, S P P P P world at [Link].
Microsoft Visual FoxPro 3.0 A, D, P, S D, P, S D, P, S P P P, S
Microsoft SQL Server A, D, P, S D, P, S D, P, S P P P P
Oracle A, D, P D, P D, P P P P
Sybase SQL Server 10 & 11 A, D, P D, P D, P P P P P
Canada/Latin America
Other Data Connectivity New in 9 9 .NET 8.5 8 7 6 5 4.5 840 Cambie Street
Unicode support New A, D, P, S Y Vancouver, BC V6B 4J2
Tel +1 604 681 3435 (International)
Access to custom COM data providers New A
Toll-free 1 800 877 2340 (US/Canada)
Access to JavaBeans New A Fax +1 604 681 2934
Access to [Link] New A, D Y
USA
Documentation and Samples New in 9 9 .NET 8.5 8 7 6 5 4.5 Suite 270
Online Installation Guide A, D, P, S D, P, S D, P, S P, S 510 Thornall Street
Online Technical Reference A, D P, S P, S P, S P, S Edison, NJ 08837 USA
Tel +1 732 321 6500
Online User's Guide A, D, P, S D, P, S D, P, S P, S P, S P, S P, S
US Federal Sales +1 888 866 8052
User’s Guide (Printed) A D, P, S D, P, S P, S P, S P, S P, S
Toll-free 1 800 877 2340 (US/Canada)
Developer’s Guide (Printed) A D D Fax +1 732 321 6504
Technical Reference Guide (Printed) D D
Online Developer's Guide A, D Y Europe/Middle East/Africa
Crystal Decisions House
Language Editions4 New in 9 9 .NET 8.5 8 7 6 5 4.5 54 The Broadway
English A, D, P, S Y D, P, S D, P, S P, S P, S P, S P, S Ealing, London W5 5JN UK
Tel +44 (0) 20 8566 2020
French A, D, P Y D, P D, P P P P
Fax +44 (0) 20 8231 0600
German A, D, P Y D, P D, P P P P
Italian A, D, P Y D, P P P P Asia Pacific
Japanese A, D, P Y D, P D, P P P P Level 9, 52 Alfred Street
Portuguese D, P P P P Milsons Point, NSW 2061
Australia
Simplified Chinese New A, D, P Y
Tel +61 (2) 9955 4088
Spanish A, D, P Y D, P P P P Toll-free 1 800 647 006
Fax +61 (2) 9955 7682
Notes:
1. Read only for Standard Edition
Website
2. Stored Procedure Support in Standard Edition is via ODBC for Access, Excel and SQL only.
[Link]
3. OLE DB support in Standard Edition for Access, Excel and SQL only.
4. Crystal Reports 9 English may also be installed on machines with Korean and Traditional Chinese operating systems. Contact us
[Link]/contact

Crystal Decisions offices

[Link]/offices

© 2002 Crystal Decisions, Inc. All rights reserved. Crystal Decisions, Crystal Analysis, Crystal Reports, Crystal Enterprise, Crystal Care, Holos and the Crystal Decisions logo are
trademarks or registered trademarks of Crystal Decisions, Inc. in the U.S. and/or other countries. All other trademarks referenced are the property of their respective owner.
Printed in Canada 20-3724

[Link]