SAP Crystal Reports 2011, Win Guia do Utilizador Página 168

  • Descarregar
  • Adicionar aos meus manuais
  • Imprimir
  • Página
    / 718
  • Índice
  • MARCADORES
  • Avaliado. / 5. Com base em avaliações de clientes
Vista de página 167
2.
Click the tab for the group you want to sort.
3.
Select the All option from the drop-down list on the left.
4.
Choose the summary that you want to base your selection on from the "based on" drop-down list
on the right.
The "based on" drop-down list on the right is for those cases in which you have multiple summaries
within a single group section. For example, in an orders report, you might sum and average the
orders for each customer and then display both the sum and the average in the same group section.
In such a case, you would select the sum or the average from this drop-down list.
5.
Specify the sort direction.
6.
To select a second group sort, repeat Steps 2-5.
When you run the report, the program will order the groups based on the summary value(s) specified.
8.3.3 Selecting top or bottom N groups or percentages
At times, you might want to show only the top or bottom groups or percentage values in a report: the
fastest selling product lines, the countries that account for the top 25 percent of sales, the states that
generate the most orders, and so on. Because this kind of selection is so popular, the program includes
the Group Sort Expert for setting it up easily.
There is one other element to consider when setting up top N: what to do with all the records from other
groups that do not fit the top N or bottom N criteria you have set. You need to decide whether to eliminate
those records from your report entirely or to lump them all together into a single group. The program
enables you to choose either option.
Note:
A report must contain a summary value in order to be able to perform a top N or bottom N selection.
See Summarizing grouped data.
It is recommended that you do not use a group that is sorted hierarchically in a top or bottom N
selection. The integrity of your hierarchical group sort might be affected by the top or bottom N
selection.
8.3.3.1 To select the top or bottom N groups
Note:
This procedure shows you how to select top or bottom N groups. Top or bottom percentages work the
same way except that you define the percentage value instead of the number of groups.
1.
Create a report and summarize the data as desired. When you summarize the data, the program
breaks the data into groups and summarizes each group.
2012-03-14168
Sorting, Grouping, and Totaling
Vista de página 167
1 2 ... 163 164 165 166 167 168 169 170 171 172 173 ... 717 718

Comentários a estes Manuais

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