Placing the Running Total Field You might recall from earlier in the chapter that when printing a summary on a group, you can put that field in either the group footer or group header and it still prints the same result. The location of a summary field doesn’t affect its value. This isn’t true for […]
3.08 Sorting in a Specified Order
Sorting In a Specified Order The second dropdown box at the top selects the sorting order of how the groups are listed. With one exception, the sorting options are what you would expect and don’t need any explanation. You can choose a sort order that is Ascending, Descending, Original Order (no sorting) or Specified Order. […]
3.24 Comparing Running Totals to Summary Fields
Running Totals Compared to Summary Fields Running totals are interesting because they have similar functionality to summary fields, and they can also be duplicated with formula fields. This can cause some confusion as to when you should use a running total, a summary field, or a custom formula field. Each of these options has unique […]
3.09 The ‘Others’ Grouping Options
The last tab in the Change Group Options dialog box is the Others tab. It lets you decide what to do with the records that aren’t otherwise specified. Since it is possible that some reports won’t need to specify how every value is grouped, this tab accumulates all the remaining values that didn’t get included […]
3.25 Using Forumulas instead of Running Totals
Using Formulas instead of Running Totals Running totals have two limitations. The first is that you are limited in the types of calculations you can do (Sum, Avg, etc.). The second limitation is that running totals are restricted to using only first pass data. For example, the formulas can’t use summary functions, the Next() or […]
3.10 Customizing the Group Name
Customizing the Group Name In most circumstances, the Group Name field displayed on the report is the field’s current value. For example, if you are grouping by country, then the group name shown on the report is the current country name. If you don’t want to display the current value as the group name, you […]
3.26 Tutorial 3-5. Using a Formula for the Running Total
Tutorial 3-5. Using a Formula for the Running Total Using a formula to replace the running total field probably sounds like a lot of work. But you’ll see that it’s really quite simple once you do it a couple times. This tutorial uses a formula to print the line number on every row, and for […]
3.11 Keeping the Group Together
Keeping the Group Together The second and third checkboxes on the Options tab control whether the report should try to keep the entire group on the same page. These properties were mentioned earlier in the Keep Together discussion within the Formatting Groups section. Setting the Keep Group Together checkbox is important if you want to […]
3.27 Advanced Tutorials Intro
Advanced Tutorials As you learned throughout this chapter, Crystal Reports gives you many options for grouping report data and customizing the output. It will probably take some practice before you become familiar with the different ways each option can be used. As you learn more about each option, you’ll discover new ways of creating advanced […]
3.12 Sorting the Grouping Data
Sorting the Group Data After creating the groups and running a test report, you may notice that although your groups are fine, the detail rows within the group are out of order. They might appear to be printed randomly or their natural sort order isn’t how you want it sorted. For example, in Figure 3-15 […]
