SAP Crystal Reports 2011, Win Betriebsanweisung Seite 527

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 718
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 526
If there is no selection formula, or if the selection formula does not pass down range limits on
Table A, the program runs a subreport for every record in Table A (26).
The number of records read by each subreport remains the same regardless of whether there was
range limit selection on Table A. Each subreport will read only those records in Table B that match
each record read in Table A (100).
23.5.6 Performance considerations for all reports
23.5.6.1 Consideration 1
With both data files and SQL databases, the program parses the entire selection formula and passes
down whatever parts of the criteria it is able to translate (pass), wherever they may physically appear
in the formula. Thus, if the formula finds criteria it can pass, then criteria that it cannot, then criteria that
it can, it passes down the first part, skips the second, and then passes down the third.
In the case of data files, the program passes down the criteria that it can to the database translation
layer.
In the case of SQL databases, the program passes down to the server the criteria that it can in the
form of a WHERE clause.
While there are exceptions, as a general rule the program can pass down any part of the record selection
formula that compares a field with a constant. Typically, this means that it can pass down any kind of
record selection criteria that can be set up in the Select Expert (equal to, one of, less than, greater than,
less than or equal, greater than or equal, between, starting with, or like constant).
There are two special selection formula situations that you need to consider. In these situations, the
record selection formula includes multiple conditions, some of which can be passed down while others
cannot.
AND situations
{customer.REGION} = "CA" and
{customer.CUSTOMER ID}[3 to 5] = "777")
In this situation, the program sees that it can pass down the condition before the And operator but
not the condition after. Since the only records that will meet the second condition will have to meet
the first as well, the program passes down the first condition, retrieves the data set that satisfies the
condition, and then applies the second condition only to the retrieved data. The rule for AND situations
is that the program passes down whatever conditions it can.
2012-03-14527
Understanding Databases
Seitenansicht 526
1 2 ... 522 523 524 525 526 527 528 529 530 531 532 ... 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 :)