* Prices may differ from that shown
Crystal Reports is the industry leader when it comes to professional looking reporting. Crystal has been around since the early 90's and has steadily evolved over the years. As Crystal uses a similar interface to Microsoft Access reporting, most people can pick up Crystal and use it with very little training.
Crystal Reports 11 comes on 2 CD's and takes approximately 10 minutes to install. The only user interaction required is to enter the 24 character serial number and also to change the CD's over. At the end of the installation a reboot may be required to ensure all files are registered successfully.
==Specifying your datasource==
Crystal Reports is very intuitive to use. Before you can produce you reports however, you need to tell the software where it is to get its data from. Crystal will allow you to use data from all of the main sources such as Microsoft Access, Excel and SQL Server, My SQL, Oracle plus a few others that you wouldn't immediately think of such as Microsoft Outlook and Exchange. If your desired data provider is not listed, you can still connect via an ODBC link providing you can find the right driver for your datasource. If this all sounds too technical, don't worry and Windows provides a nice simple wizard for setting up these connections should you need to.
Once your datasource is specified, you can now select which tables, or views will be used for displaying your data. This is a simple drag and drop operation. Once this has been accomplished, you are ready to start being creative.
==Designing the report==
It is worth having an idea in your head, or better still, drafted out on paper before you start using the Crystal designer. The options available to you are endless so it is very easy to get into a tangle if you are not exactly sure of what you are trying to achieve.
For a simple text-only report, all you need to do in essence is just drag the fields from the field list and place them onto the page where you want them to appear. You would then publish the report and that would be it. In most cases though, you will want to do far more with your report such as total individual columns, categorise your report with grouping and maybe even add a graph or two for that extra wow factor. All this is very simple to do in Crystal within a matter of minutes.
With Crystal's drag and drop interface I find it is very easy to create professional looking documents in virtually no time at all. The adage, a picture paints a thousand words is certainly highlighted with Crystal. All the charts available are the ones commonly found in products such as Microsoft Excel and are all easily configurable to represent the data that you are trying to portray. Pictorial representations of data are usually a lot easier to understand than plain text, therefore an excellently designed report could be the difference between winning or losing a sale from a salespersons perspective.
==Previewing your report==
Once you have finished creating your report, it is best to preview it, just to make sure everything looks just as you intended it to. The first time you use preview, Crystal will go away and retrieve live data so you can see exactly how things will look. If you are unhappy with the layout or content of your report, simply go back into design mode and make your changes. What I like about Crystal is that after the initial preview, you don't need to retrieve the data every time meaning that you can test out small changes very quickly without the need to wait for data to load each time. You can request that the data is refreshed should you wish to but I would only advise you do this is there was a problem with the data in the initial preview and you have since manipulated your datasource.
==Why use Crystal==
So far I have mentioned that Crystal is similar to the Access report writer and contains all the charts that Excel does, so why buy Crystal when other packages appear to achieve the same results. The main advantage Crystal has over its competition is the way it can be deployed, especially over the web. In a commercial environment, people want real time data at their fingertips. With Excel, the data is likely to be static and Access reporting does not sit very well on Wide Area Networks. Crystal, however, because it is linked into a datasource will always be looking at live data meaning that users will always be confident they are retrieving upto date data. Crystal reports are fairly straightforward to deploy over the web providing you have the correct runtimes installed on the webserver. This is the only real technical ability you will need to have. Once a user has run a crystal report online, they can export it to another format should they wish to or even save it as a PDF document without the need for a separate PDF writer.
Crystal reports offers similar reporting options to Microsoft Access and Excel plus a lot more. The flexibility in this application is almost endless. If you are required to produce extremely high quality outputs on a regular basis then there are no real alternatives. Crystal is the market leader for a reason. It is simple to use, extremely powerful and its portability makes it the only real contender for web reporting. The only real drawback to Crystal is the cost. A single user licence cost us just over £300 so this is only really viable for the business user.
Crystal Reports is currently the industry standard in report writing. It is very versatile, in that it can read a wide variety of databases and is extremely rich in features. It produces reports of highly professional quality, which is its main attraction. It is easy to learn, but extremely tedious to work with. It is also extremely slow and riddled with obvious bugs, which are often not fixed in newer versions. There is one bug in particular that I encounter at least 50 times per day. It has been in every release of Crystal since at least version 8.5. How do I know? Because there used to be an article in the Seagate knowledge base with a workaround for it in version 8.5. I have to use this workaround 50 times per day in all versions.
Crystal is especially difficult to deploy. The .NET features are notoriously unstable, and you should expect to spend many man hours troubleshooting Crystal issues on individual workstations accross your user base who will not be able to print anything. Frustration among end-users (e.g. my customers) can be very high. It is not uncommon for a PC workstation to have more than one software application that is dependent on Crystal, which will have installed conflicting versions of the product. This is a tech support nightmare. Crystal Reports is an extremely unpopular product among us computer programmers. Personally, I can't thing of a single software package anywhere that is more overrated. All versions and editions have serious problems. But you don't need to take my word for it. Here are links to two long blogs by programmers who express their frustration with this product. There are others you can easily find with Google if you include some expletives in your search criterion.
Crystal Reports XI provides for dynamic and cascading prompts. This means that report designers can base report prompts on dynamic values. They no longer need to maintain static prompt value lists within individual reports and they can reuse existing prompts stored in the repository.
The new RTF export format is excellent for report export editing. This complements the existing RTF export of optimized accuracy and forms processing. The result is that the end user is now able to enhance and expand a report in standard word processing applications.
Pictures and graphics can now be placed in a report through a link in the database so that it is no longer necessary to store images within the database. This supports the common practice of storing images on the web server and storing references to those images in the database.
New drag-and-drop charting and cross-tabs allow for intelligent charting approximates variables when a chart is dropped into a section. Chart design is now faster and easier because charts will be updated automatically when new variables are added.
The iterative report design/view process is streamlined, with a new HTML preview that allows report authors to see how reports will look when published to the web.
Use the Dependency Checker to instantly find broken links, formula errors, and dependency issues before reports are published and distributed.
Using the Workbench and the Repository Explorer, users can easily browse, build, and publish object packages. With object packages, users can schedule, manage, and secure a group of reports together rather than just one report at a time.
The Workbench allows users to keep projects organized by grouping reports according to preference.
The new Repository Explorer simplifies navigation within the BusinessObjects Enterprise system and reporting components can be easily shared among users within the Crystal Reports Designer.
Designing reports is easier with the Getting Started page that appears each time you open Crystal Reports. The updated Visual Report Designer allows you to point and click so you can create reports without the need for intensive coding.
Crystal Reports XML, JDBC, IBM DB2, and Exchange data drivers have been updated to give you an incredible range of data access options.
New Patch Installation feature means that all customers will have the most up-to-date version of Crystal Reports XI because they will automatically receive the latest hot fixes and service packs.
Single Sign-OnSingle sign-on is a new feature. Now Crystal reports can be integrated into an existing security infrastructure.
Enhanced Support for Business Objects Universes support has been enhanced for Business Objects universes (the semantic layer for BusinessObjects business intelligence tools like Web Intelligence), to include universe view time security and union queries.
Complete Integration with BusinessObjects Enterprise Architecture. Enjoy seamless continuity between all of the applications within your business intelligence technology suite. Scalability is easier when everything is integrated.
Report export configuration information can be saved with the report so that end users forgo the time and trouble of reconfiguring the export each time a report is run.
Hierarchical grouping has been enhanced, providing increased layout control so that users can create their reports in a hierarchical, rather than just a relational, manner. This provides a better fit for organizational charts and summary reports.
Parameterized control for N value for top N style reports means that a single report will meet the needs of multiple users. This will reduce the total number of reports that are created and supported.
Crystal Reports Standard Edition provides access to PC-based data sources which can then be used to create highly formatted reports.
|Product Description:||SAP Crystal Reports XI Standard Edition - complete package|
|Subcategory:||Business - databases / database tools|
|Licence Type:||Complete package|
|Licence Qty:||1 user|
|OS Required:||Microsoft Windows XP, Microsoft Windows 2000 SP4 or later|