Single group by layouts are prepared by first designing one or more Summary reports, each with a single field as the object of the summary list. For example, you may prepare a Summary report using the product_name or the area field. Any filters may be applied to each of the reports.
Further, each of the summary reports may use a different field as its object. This will allow you to prepare a layout where each row or column of the layout represents a totally different variable being counted. Thus you can have different rows or different columns represent different information on a single report.
To prepare a Single Group By layout report, choose the Create layouts for existing reports from the Query / Report Options list and press the GO button. You will see the following screen:
Preparing a single group by report
Note that the radio button selection at the top of the screen already reflects your choice of the Single Group By report. To prepare the report:
Setting the style of an element on a PDF report
First create and save three summary reports. Each of these has the product_name field (titled Product) as the selected field. For each of the three reports, select a single filter, as follows for each report:
You will now have three summary reports titled something like:
Now we will place these fields onto the layout:
Sample Single Group By Report
Notice how we supplied the field to group by as Product and then set up three queries to include. Of course, these are the three summary reports we set up earlier in the example.
For this example, we also set up some additional header rows as shown on the screenshots. If we save this, then include into a container report, and run the container report, we will see results similar to this:
Sample Single Group By Report