With this combination of properties, all companies starting
with A will be grouped together, those beginning with B will be in another group, and so on.
For this example, a slightly different report is used to illustrate prefix character grouping. This
report (rptSalesJan08Alpha1, shown in Figure 20-6) shows purchases during the month of
January 2008, sorted by customer name. The order date, order ID, and the employee filling the
order are shown across the page. The result of the sorting and grouping specification in Figure
20-5 is shown in Figure 20-6. (Hide Duplicates has been set to Yes for the CompanyName field so
that each customer appears only once in the list.)
It??™s important to note that the data shown in Figure 20-6 is identical to the data in Figure 20-4. In
fact, the same record source (qrySalesJan08, shown in Figure 20-2) is used for both of these
reports. Often, a data rearrangement yields useful information. For instance, you can easily see that
Around the Horn placed two orders in January with the same sales agent, Janet Leverling.
Pages:
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292