SAP 7090310 Fiche technique Page 125

  • Télécharger
  • Ajouter à mon manuel
  • Imprimer
  • Page
    / 706
  • Table des matières
  • MARQUE LIVRES
  • Noté. / 5. Basé sur avis des utilisateurs
Vue de la page 124
enhance and hone your formulas in ways that are either difficult or impossible with SQL. In certain
circumstances, however, creating and using SQL Expression fields can speed up the processing of
your reports.
6.5.5.1 Key uses of SQL Expression fields
To maintain optimum report processing speeds, avoid using formulas (whether Crystal or Basic syntax)
within record selection formulas. Instead, replace the original formula with an equivalent SQL Expression
field, and then incorporate the SQL Expression field into your record selection formula. Doing so will
greatly improve the chances of your record selection being pushed down to the server.
In addition, avoid sorting, grouping, or totaling on a formula field (whether Crystal or Basic syntax).
Instead, replace the original formula field with an equivalent SQL Expression field, and then sort, group,
or total on the SQL Expression Field. Again, this will greatly improve the chances of the processing
being done on the server.
Finally, if your database supports Case Logic, and your report needs to summarize an If-Then-Else
formula calculation, replace the formula with an SQL Expression field. In such cases, SQL Expression
fields enable Crystal Reports to perform the report's grouping on the server. For more information, see
Using SQL Expressions for Case Logic.
Related Topics
• The SQL language
• SQL Expression fields
• Using enhanced record selection formulas
6.6 Improving grouping, sorting, and totaling
6.6.1 Performing grouping on server
If you're reporting in real-time off live data over the Web, reduce the amount of data transferred from
the database server by using the Perform Grouping on Server option. With this option, much data
processing is off-loaded to the database server and only a subset of data is read initially. Detail data is
returned from the database only when you drill down in a report.
2011-05-16125
Designing Optimized Web Reports
Vue de la page 124
1 2 ... 120 121 122 123 124 125 126 127 128 129 130 ... 705 706

Commentaires sur ces manuels

Vikixwk 04 Jan 2024 | 13:20:14

urenrjrjkvnm

Viktorihon 14 Jan 2024 | 00:44:53

Cinema

Tekmar 362 Mixing Control Installation manuels

Manuels d'utilisation et guides de l'utilisateur pour Capteurs Tekmar 362 Mixing Control Installation.
Nous fournissons des manuels en pdf 1 Tekmar 362 Mixing Control Installation à télécharger gratuitement par type de document : Manuel de l'utilisateur






Plus de produits et de manuels pour Capteurs Tekmar

Modèles Type de document
363 Universal Reset Control User Manuals Manuel de l'utilisateur   tekmar 363 Universal Reset Control User Manuals User Manual, 4 pages
363 Universal Reset Control Installation Manuel de l'utilisateur   tekmar 363 Universal Reset Control Installation User Manual, 40 pages
362 Mixing Control User Manuals Manuel de l'utilisateur   tekmar 362 Mixing Control User Manuals User Manual, 4 pages
364 Universal Reset Control User Manuals Manuel de l'utilisateur   tekmar 364 Universal Reset Control User Manuals User Manual [ru] , 4 pages
365 Mixing Control Manuel de l'utilisateur   tekmar 365 Mixing Control User Manual, 16 pages
367 Zone Control Manuel de l'utilisateur   tekmar 367 Zone Control User Manual, 16 pages
368 Zone Control Manuel de l'utilisateur   tekmar 368 Zone Control User Manual, 12 pages
364 Universal Reset Control Installation Manuel de l'utilisateur   tekmar 364 Universal Reset Control Installation User Manual, 36 pages
369 Zone Control User Manuals Manuel de l'utilisateur   tekmar 369 Zone Control User Manuals User Manual, 8 pages
369 Zone Control Installation Manuel de l'utilisateur   tekmar 369 Zone Control Installation User Manual, 32 pages
370 House Control Manuel de l'utilisateur   tekmar 370 House Control User Manual, 20 pages
371 House Control Manuel de l'utilisateur   tekmar 371 House Control User Manual, 20 pages
400 House Control Installation Manuel de l'utilisateur   tekmar 400 House Control Installation User Manual, 32 pages
400 House Control Quick Start Manuel de l'utilisateur     tekmar 400 House Control Quick Start User Manual, 12 pages
374 Universal Reset Control Manuel de l'utilisateur   tekmar 374 Universal Reset Control User Manual, 36 pages
401 House Control Installation Manuel de l'utilisateur   tekmar 401 House Control Installation User Manual, 28 pages
401 House Control Quick Start Manuel de l'utilisateur     tekmar 401 House Control Quick Start User Manual, 12 pages
402 House Control Quick Start Manuel de l'utilisateur     tekmar 402 House Control Quick Start User Manual, 12 pages
402 House Control Installation Manuel de l'utilisateur   tekmar 402 House Control Installation User Manual, 32 pages
403 House Control Quick Start Manuel de l'utilisateur     tekmar 403 House Control Quick Start User Manual, 12 pages