Crystal Reports Solutions: Slow Report Performance

Users are complaining about slow report performance. Data refreshes take forever, and even receiving the report makes people grit their teeth. The basic problem is your network can't handle the load, so everything slows to a crawl and "report performance" is the office joke. Your boss is at wits end, and you know you're in trouble if you don't fix this--and fast. So far, you have:

• Used Report Analyzer to optimize your reports (you have done this, haven't you?).

• Reduced the Crystal Reports distribution to lighten the load.

• Found out that upgrading the network is out of the question.

What else can you do?

Fortunately, there is something you can do. And it doesn't cost much. You have to tackle the traffic at its source. We have a software solution to allow you to do just that.

Solving the report performance problem

This is what we recommend. This solution takes the form of an inexpensive Crystal Reports Scheduler. A Crystal Reports Scheduler is a tool that automates report distribution. You can "set it and forget it." Using manual methods, you must interact with the reporting system for you to actually distribute the reports. But a Crystal Reports Scheduler interacts with the reporting system for you. That provides many benefits.

Now, here's the really neat part. You solve not just the report performance problem, but you will also prevent any of the following problems--or solve them, if you already have them:

• Data crashes.

• Manual report distribution, which is costly.

• Labor-intensive distribution, due to manual methods.

• Being tied to a daily grind mandated by user report schedule demands

• Late report deliveries, missed report deliveries, and duplicate report deliveries.

• Interruptions due to report delivery activities.

• Interruptions of report deliveries due to emergencies, sickness, conferences, meetings, or other priorities.

• Inability to use the same report multiple times with different parameters and/or destinations.

• Inability to upgrade the network to handle the increased report traffic.

When you use a Crystal Reports Scheduler, you can:

• Schedule reports for automated delivery during non-peak hours. This alone justifies the cost of a Crystal Reports Scheduler several times over. What do you think it would cost you to upgrade your network? Going from 100MB Ethernet to 10GB Ethernet means all new cables (and LAN testing)--and that alone is thousands of dollars you won't need to pay if you use a Crystal Reports Scheduler.
   

• Break the ankle chain that requires real-time presence during report distribution. For example, if you want to distribute reports an hour before normal starting time to reduce peak loading on the network, a Crystal Reports Scheduler allows you to do that without your needing to also be there an hour before normal starting time.
   

• Ensure on-time deliveries of your Crystal Reports to the right people. No more late deliveries, no more missed deliveries, and no more accidental deliveries to the wrong people or to the same people 2 or 3 times.
   

• Eliminate interruptions in your work flow, due to needing to deliver reports at a set time.
   

• Eliminate interruptions in your report deliveries, due to emergencies, sickness, conferences, meetings, or other priorities.
   

• Use the same report multiple times with different parameters and/or destinations. This eliminates several potential problems, right at the source. Plus, it saves you time.

At this point, you are probably "sold" on the need for a Crystal Reports Scheduler. But now you are faced with the task of evaluating the various Crystal Reports Schedulers on the market and deciding which one to buy.

Of course, we are going to recommend one of our own Crystal Reports Schedulers and not one sold by our competitors. But there is more behind that recommendation than simply wanting to be your source for a Crystal Reports Scheduler. We also have a track record of continual development, giving you a full-featured product to fill your needs efficiently.

So, what are the choices? First of all, if you are running Crystal Enterprise you already have a Crystal Reports Scheduler built in. This approach gives you a Web-based reports distribution.

But if you are not running Crystal Enterprise, you need a strong Windows-based Crystal Reports Scheduler. Two such products are:

• cViewSERVER. This is a scheduler that runs as a Windows service, which means you don't have to be logged in for it to run. It's built on the .NET platform, and that gives it major performance advantages. But you must run Crystal Reports 9.0 or higher to be able to use it.
   

• cViewMANAGER. This is our original scheduler. It runs as a Windows application, and it is compatible with earlier (pre-9.0) versions of Crystal Reports. Like cViewSERVER, it has a high level of functionality with major benefits.

Isn't it about time you started saving your company money with a Crystal Reports Scheduler? Insist on quality--insist on cViewSERVER or cViewMANAGER.

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.