The Column Breaks configuration tool provides the ability to add one or more column breaks to your report. When a column break is added on a column, sorting is applied to that column that takes priority over other sorts you may have specified. Identical values in that column are grouped together and an additional blank row is inserted at the point where the value in the column changes.
After a column break has been added, you can choose to Suppress Details. This collapses the report so that a single row is displayed for each unique value in the Column Break column. Any of the numeric columns in the report that have not had column breaks applied but have had totals or averages applied will display a total or average for each row.
When you have Column Break together with Totals or Averages, and you want to display additional columns on the sub-total rows, you can select the Display Value on Breaks option from the column header for the desired columns. For example, if you are breaking on a customer ID, and displaying total sales, you may want to also display the customer name on the sub-total row along with the ID and total sales.
Add a Column Break
There are two ways to add a column break to a report. The first is from the Column Breaks configuration tool. Move the column or columns that should have column breaks applied from the Available Break On Columns list to the Columns Currently Breaking On list and click View Report. The second way is to select Break On Column from the column header menu of the column that should have column breaks applied. To apply multiple levels of column break, the Column Breaks configuration tool must be used.
Column Breaks cannot be added to Date Range columns.
Suppress Column Details
When viewing a report that includes one or more column breaks, a new option becomes available just below the tool bar to the right of the page count. It is labeled Suppress Details. When this link is clicked, the report will be collapsed so only one row for each unique value that exists in the column will be displayed. If totals or averages have been applied to other columns, those will also be displayed.
Click the + in the left-most column of the report to expand a row and see all of the rows in that section.
To remove the detail suppression and view all of the detailed rows again, click the Show Details link just under the tool bar where the Suppress Details link previously was located.
On suppressed detail reports, you can sort on both break-on columns and totaled/averaged columns. Sorting will override the break-on behavior, but it will still do breaking where possible.
Only Break On, Total, and Average columns will be sorted when viewing a suppressed details report.
When the details have been suppressed in a report, a new column is automatically added to the report displaying the number of rows in each collapsed section. This column can be removed from your report by clicking Hide Row Count in the tool bar, directly to the right of Show Details link.
Modify Column Break Order of Precedence
If more than one column break has been added to a report, a Column Break Order of Precedence will need to be set to define which column break should be set first, second, third, and so on.
To set or modify the Column Break Order of Precedence, navigate to the Column Breaks configuration tool. Reorder the columns in the Columns Currently Breaking On list as needed, placing the column that should have the column break applied first at the top of the list.
Remove Column Break
There are three ways to remove a column break from a report.
- From the Column Breaks configuration tool, drag the column(s) that should no longer be used for column breaks from the Columns Currently Breaking On list to the Available Break On Columns
- From the Column Breaks configuration tool, click the Remove All Breaking for this Report link at the bottom of the page.
- From within a report, select Remove Break On Column from the column header menu of the column that should no longer be used for column breaks.
Article is closed for comments.