- Platform: Windows NT / 98 / 2000 / 95
- Media: CD-ROM
- Item Quantity: 1
System Requirements
Product Details
Would you like to update product info or give feedback on images?
|
Product Description
Amazon.com Review
Structured Query Language (SQL), the standard means of specifying what information you want to extract from a relational database, was designed by programmers for programmers. In order to extract values from tables with straight SQL, you have to formulate convoluted statements from field names and cryptic keywords--which doesn't usually leave time available for making business decisions. The makers of Crystal Reports 8.5 Developer Edition understand that writing SQL statements isn't everyone's favorite thing to do, so Crystal Reports 8.5 Developer Edition provides tools that make it easier to extract meaningful information--in the form of charts, tables, and calculated values--from the contents of database management systems like Oracle, Sybase, and Microsoft SQL Server. The developers of Crystal Reports also knew that some people love to manipulate data at a low level with SQL and other programmers' tools, so the package contains goodies for them, as well.
As is often the case with enterprise solutions, this product consists of two separate applications. The core package, Crystal Reports 8.5 Developer, is for accessing the contents of database tables and generating reports based on their contents. Wizards make this process extremely easy. You just specify the database you want to operate on, which can be local or accessible via an Open Database Connectivity (ODBC) link. Having done that, you can choose the tables and fields you want to extract values from. The wizards make it easy to specify which fields should serve as headers, and simplify the process of doing calculations on extracted values. In a report on the monthly sales of a multinational chain of stores, for example, you could group individual stores' sales figures by country, and calculate total sales figures for each country and for the chain as a whole. Wizards also handle formatting, so it's pretty easy to get neat-looking reports customized with your organizational logo. Wizards aren't limited to tabular reports: you can use them to generate reports that reveal details in response to clicks (so-called drill-down reports) and personalized form letters for mass mailings.
Going beyond the wizards, Crystal Reports 8.5 Developer offers a tool for visually creating joins among tables (by which you can consolidate the fields in multiple tables into a single report). It also makes it relatively easy to build SQL queries, mostly by exchanging syntax memorization in favor of a logically organized set of expandable trees from which you choose the commands you want. With SQL queries, you can do things like find the maximum value in a field across many records, or perform complicated text-searches on the contents of text fields. Managers and others who have been taught to revere database queries as a black art known only to database administrators will be delighted by the ease with which they can create reports to support their business decisions.
The other product in this package is Crystal Enterprise 8, which is capable of taking report documents from Crystal Reports and distilling them into publications that it then serves to network users. There are several ways to go about preparing reports for network publication, the simplest being nearly automatic conversion of Crystal Reports documents into Dynamic HTML (DHTML) files that standard Web browsers can read. With a little more work, Crystal Enterprise will serve reports in streaming form--meaning they're updated dynamically as their underlying data changes. It'll also generate Adobe Acrobat (PDF) files, as well as reports delimited by Extensible Markup Language (XML) tags. The XML feature is especially cool, because it means you can use Crystal Enterprise as an engine for generating business documents (such as invoices and purchase orders) that are fed to business partners via an XML-based information-exchange system, such as Microsoft BizTalk Server.
Because it's easy to use and flexible in its output, Crystal Reports 8.5 Developer Edition belongs in the toolkit of anyone who's responsible for sharing complicated information--especially numerical information--with others via a network. --David Wall
Amazon.com Product Description
Crystal Reports allows you to deliver rich, interactive content from virtually any data source, publish it to the Web, and integrate it within applications. It includes the following features: report viewers (including DHTML, ActiveX, and Java), a Web-based report-management system, Web server with licensing for five concurrent users, a customizable Web desktop, and report delivery regardless of location or platform.
There are also report types (subreports, conditional, summary, cross-tabs, form, drill down, OLAP, top N, multiple details, mailing labels), hyperlinks, charting, mapping, parameters, alerts, add-ins for Excel and Access, sorting, running totals, grouping, top N, bottom N, image format support, formula editor, experts, and more. The program also provides drivers and support for more than 30 SQL-, ODBC-, OLE DB-, and PC-based data sources, including XML.
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
21 of 23 people found the following review helpful:
3.0 out of 5 stars
Nice for reporting, but has some really annoying bugs,
By
This review is from: Crystal Reports 8.5 Developer Edition (CD-ROM)
Crystal Reports 8.5 provides a lot of features for designing reports on top of a relational database system and as far as consumer-tier goes, it's a fine product. Charts are pretty easy to use, the macro language is fairly powerful (and intuitive), and it's very easy to lay out items on the report.There are several annoying problems with it: 2. The table linker is nice, but it is more primative than the one in Microsoft Access. For example, if I'm joining three fields from table "foo" to table "bar," and I make one of those joins a "right join" then the others two parts of the table join should default to this. They don't and it errors out. I feel the tool could be easier to use. 3. On several occasios the query tool got hopelessly confused. It was often easier to write a custom view or macro query on SQL Server (or Oracle) than it was to use the reporting front end. The problem I have with this is it makes my particular installation harder to do because in addition to just shipping a standalone report, I have to ship a SQL query. I wish there were a way for me to reliably tell it "I KNOW what I'm doing... ust send the query as I've typed it to the database." 4. Occasionally when a query had problems with it and I attempted to preview the report, it would go into "infinite loop" mode. The only way out of this was to use Windows to "kill" the program. Quite frequently, I'd have crw32.exe just crash on its own when accessing a SQL database.
13 of 13 people found the following review helpful:
1.0 out of 5 stars
Programmer's Nightmare,
By A Customer
This review is from: Crystal Reports 8.5 Developer Edition (CD-ROM)
I don't have the space to convey just how much production time is continually being lost to this abysmally bad product in our shop of senior developers. I could go on for days. Try a little experiment before buying it: go to the CrystalDecisions website and look at some of the most common errors reported. Basic stuff like INSTALLING the product, getting it ready to package up with an install application, pointing it to a DB through just about any connection technology. And it's all downhill from there. I still don't get why there isn't a better product out there yet.
11 of 14 people found the following review helpful:
1.0 out of 5 stars
Programmers beware.,
By Lawrence McGinnis (Running Springs, CA United States) - See all my reviews
This review is from: Crystal Reports 8.5 Developer Edition (CD-ROM)
The program is full of holes and traps for the programmer. The new method of including the report in VB programs uses a lot of overhead and slows a VB program down if the number of reports is more then 4 or 5. Some necessary dependacy files are not included and it will not easly load onto computers not using the internet (a great many business computers). Crystal Software includes a 60 days support package that is not at all enough. Just visit the Crystal developer web site to view some of the problems. Save your money and use your older versions until they get it right.
Share your thoughts with other customers: Create your own review
|
|
