SAP Crystal Reports 2011, Win Betriebsanweisung Seite 117

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 718
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 116
For a complete description of how table indexing works, see Indexed tables.
6.4.3 Improving table-linking choices
When you add multiple database tables to your report, you link the tables on a common field so that
records from one table match related records from another. (Table linking works best if your database
tables are indexed.) Linking your database tables in this way is usually much faster than incorporating
linked subreports into your main report.
When you link two or more tables, you want your report to read as few records as possible, while at
the same time finding all matching records. The best ways to adhere to this guideline are to assess
your reporting needs and to plan your strategy before creating your report. When you know exactly
what you need from your data source, Crystal Reports makes it easy to get that information.
There are many other specific issues to consider when linking tables. These additional considerations,
however, are largely contingent upon your reporting environment. In other words, the steps to optimal
table-linking performance depend upon your database type, the possibility of indexing tables, and the
join type required between tables. You'll find complete descriptions for various reporting scenarios in
the section entitled Linking tables.
In the majority of reporting scenarios, the following general procedures should ensure that your tables
are linked for improved if not optimal performance.
6.4.3.1 To link tables effectively
1.
Ensure that each database table is indexed on the field you are going to use.
2.
Add the database tables to your report, and then link from the primary table to the lookup table on
a common field. (Do this instead of inserting a linked subreport and binding it to the data in your
primary report.)
3.
Use a record selection formula that sets range limits on the indexed field in the primary table. This
minimizes the number of records in the primary table for which Crystal Reports must find matching
records in the lookup table.
6.4.4 Using thread-safe database drivers
If you share and refresh reports over the web, open them using thread-safe database drivers whenever
possible. The Crystal Report Engine supports multiple threads. Thus, when you make multiple data
2012-03-14117
Designing Optimized Web Reports
Seitenansicht 116
1 2 ... 112 113 114 115 116 117 118 119 120 121 122 ... 717 718

Kommentare zu diesen Handbüchern

Edwinfet 29 Feb 2024 | 08:13:09

What are the upsides of contracting skilled web optimization organizations? Expert search marketing companies utilize teams of experts focused on elevating your site's content for browsing engines. This encompasses researchingsearch phrases, adjusting on site characteristics, and managing off-domain enhancements. Moreover, these firms monitor adjustment in from Google parameters and refresh the text on your website as needed. This saves both you your time and your workers from unwanted a

KarenSkaky 17 Apr 2024 | 10:11:41

Securing the security of your home is essential in today's unsettled times. Among the best ways to safeguard your belongings and peace of mind is by committing in a trustworthy safe. Regardless of whether you're securing money, important documents, or precious heirlooms, a safe gives a protected repository solution. Regarding selecting the right safe for your house, there are several elements to consider. Above all, assess your safety requirements. Determine what items you plan to store in

Helenlal 18 Apr 2024 | 08:19:10

Arranging an open-air wedding in Phenix and anxious about the unpredictable weather? Don't let Mother Nature rain on your parade – truly! At [Event Rentals Phoenix], we provide stunning wedding tent rentals that will ensure your distinctive day goes off without an hitch. Our wedding tent rentals are created to supply both charm and functionality. Say "I do" under tha elegant canopy of one of our tents, surrounded by your loved ones and tha breathtaking scenery of Pheonix. With one assortmen

Helenlal 29 Apr 2024 | 05:23:21

In both personal and professional situations, encountering issues is unavoidable. However, mastering productive trouble-shooting techniques is key for triumphing over hurdles and accomplishing success. In this piece, we delve into the strategies and methods for efficiently addressing dilemmas. From analytical thinking to creative brainstorming, we look into various approaches that can help individuals tackle challenges with certainty and accuracy. Effective challenge solving begins wit

Chrisnug 29 Apr 2024 | 14:39:54

Hello, im noob :)