Tutorial 3-6. Sales By Country and Product Type.rpt Before getting into the tutorials, we first need to build the base report that is used for tutorial 3-7 and 3-8. This will be used for demonstrating how to modify an existing report so that it can handle dynamic groups. On the Start Page click Standard Report […]
3.13 Reordering the Groups
Reordering the Groups Sometimes you might create a report with multiple groups and then decide that groups should be rearranged. For example, a report that sorts first by state and then by product could be changed to sort by product first and then state. There are two ways to reorder the group fields. The first […]
3.29. Tutorial 3-7. Dynamic Grouping Fields
Tutorial 3-7. Dynamic Grouping Fields In this tutorial we will base the groups on formulas. We will fix the previous report so that it shows either both groups or only one group. This gives the user the ability to choose how the type of report they want to see. There are three changes that need […]
3.14 Tutorial 3-2. Grouping by a Specified Order
Tutorial 3-2. Grouping by a Specified Order Crystal Reports has an excellent sample report that demonstrates how to create a grouping report using the specified order option. The report Group By Intervals.rpt is a sales report that shows total sales from the prior year for each customer. Each customer is broken down into three categories […]
3.30 Tutorial 3-8. Dynamic Group Sorting
Tutorial 3-8. Dynamic Group Sorting When creating a group, you have to specify the order to sort the data in (the default is ascending order). To make a report more flexible, you can let the user choose how to sort the report. For example, a person who wants to see the most recent sales activity […]
3.15 Displaying Top N Reports
Displaying Top N Reports An alternative to standard grouping is to create reports that show the first or last set of records in a certain group. For example, rather than showing all the sales people for the company, you could show the top 5 sales people that have the best sales for the month. Or […]
3.31 Tutorial 3-9. Group Headers that Repeat
Tutorial 3-9. Group Headers that Repeat When grouping data, it is common to repeat the group header section at the top of each group. This can include printing the group name and column headers. While this is very helpful, there are times when this makes things tricky because you don’t always want the group header […]
3.16 Grouping on Summary Values
Grouping on Summary Values The Group Sort Expert dialog box actually has a dual purpose. In the previous section, I quickly skimmed over the fact that the dropdown box defaults to the value All so that all groups are displayed. But this setting is also useful for creating new ways of sorting your groups. Normally, […]
3.32 Tutorial 3-10. Formatting Hierarchical Groups
Tutorial 3-10. Formatting Hierarchical Groups Hierarchical groups (discussed earlier in this chapter) give you the option to customize the indentation level of each child record. This shows a tree-view structure illustrating the relationship between the parent and child records. You can also have them line up directly below each other when there is a limited […]
3.01 Sorting Records
After learning the basics of creating simple reports, you will quickly find yourself developing reports that are more involved then just listing sequential records one by one. For reports that consist of dozens, if not hundreds, of pages, providing a meaningful format that groups the data into logical units goes a long way towards making […]
