SAP Crystal Reports 2011, Win Guía de usuario Pagina 358

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 718
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 357
A database ranking allows you to specify a ranking at the query and database level so that the data
returned to Crystal Reports by the query is already ranked. This has the following advantages:
Ranking data can be processing-intensive. By ranking at the database level you allow the server,
which is typically far more powerful than the client machine, to perform this processing.
Pre-ranking data reduces the amount of data retrieved across the network and stored in Crystal
Reports.
Note:
You can perform a database ranking only if your database supports it. If this is not the case, the
"Add a top bottom" button is disabled on the Query Panel toolbar. Databases that support ranking
are Oracle, DB2, Teradata and Redbrick.
Crystal Reports uses the SQL-99 Rank function in ranking SQL.
SQL is the query language supported by all relational databases (RDBMS), although each database
has its own syntax.
16.6.4 Creating a database ranking
You create a database ranking in the Query Filters pane of the Query Panel.
Note:
You can mix database rankings and other types of query filter in the Query Filters pane.
16.6.4.1 To create a database ranking
1.
Add the objects that you want to appear in your query to the Result Objects pane of the Query Panel.
2.
Select the object that you want to rank by.
3.
Click Add a database ranking on the toolbar.
The ranking outline appears in the Query Filters pane. The object that you selected appears as the
ranking dimension, and the first measure in the query appears as the ranking measure in the "Based
on" list.
Note:
The "Add a database ranking" button is disabled if your database does not support ranking.
4.
Select the ranking direction (Top or Bottom).
5.
Type the number of records you want the ranking to return in the box next to Top/Bottom.
2012-03-14358
Building Queries
Vista de pagina 357
1 2 ... 353 354 355 356 357 358 359 360 361 362 363 ... 717 718

Comentarios a estos manuales

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 :)