I’m sure that from time to time you face serious problems with your reporting. It’s clear that your customers expect a sort of miracle from you. To be exact they want everything to be perfectly summarized and displayed in a readable form. But to your great regret very often you have to spend more time on generating reports due to some problems arising suddenly. It goes without saying that it’s very frustrating for you.
In fact almost every Crystal Reports developer faces this inconvenience very often. So you aren’t the only one person in the world suffering from this. But to your great luck it’s really possible to combat this bad performance. You only need to be aware of what causes poor performance. Accordingly in this case you’ll be able to mitigate these negative effects.
You should pay attention to your database set up. Of course this may not be within your control. But you should keep in mind that very often databases aren’t set up perfectly. I’d like to stress that those fields filtered on by you aren’t indexed. In fact you can check it by simply referring to the Linking Tab. This tab is in the Database Expert window. Colored markers usually indicate indexed fields.
By the way it’s possible to run your reports about hundreds of times quicker. In this case you only need to add an index to an important field. From my point of view using a view instead of a table to report may appear to be rather devastating to your reporting performance. The matter is that views haven’t got indexes. I’d like to remind you that a view is a just a collection of tables used to simplify data for users.
The only one way to avoid this inconvenience is to report on those tables that make up the view. You need to identify whether this particular source of a field is a view or a table. You can easily do it with the help of the Database Expert. This tool lists tables and views separately.
It goes without saying that identifying tables that make up a view is rather challenging. Most probably that you’ll require some database documentation. By the way if you use Oracle databases then it’s advisable for you to turn off the case sensitive option. In my opinion it will significantly speed up your reporting time. But on the other hand you may require rewriting some existing reports.
I suppose that you use the wrong ODBC driver. I should say that ODBC drivers are responsible for attaching Crystal Reports to the database. Some ODBC drivers work only with one kind of database. They also differ in performance. You should test several drivers to select the best one. I hope everything will be ok with your Crystal Reports.
we are living in the world of modern technologies. These days the more your activity is automated, the better, especially when it refers to Reporting Services. Reporting is a very helpful thing. So if you need to automate your reporting activities, you might think of using SQL Server solution. Automated reporting will help eliminating repetitive tasks and saving time and money. Look through this SQL Server Reporting Services site to find out more details.
And remember that our world is the world of modern Internet technologies. It would be intelligent to use the online network to search for anything on the best terms available on the market. Search engines, social networks, blogs and forums – all this will assist you to solve many issues.
convert this post to pdf.