Time for action – adding groups
If we preview our report, we will be able to see the following:
However, if we compare these results with the ones obtained by MySQL, we will note that the PRD groups are not being created properly.
As we can see, the highlighted customers appearing in our report belong only to Canada; that is, our report is showing incorrect results.
In order for the groups to be correctly formed, we need to go to the Structure tab, navigate to Master Report | Group, select it, and modify the following:
Attributes.group =
[country_id]Attributes.name =
GroupCountry
What we just did was indicated to PRD that the groups should be formed by these registries, which share the same country_id values. We could have put just country instead of country_id, but it is much more efficient to use fields of a numeric nature. With respect to GroupCountry, it is the name by which this group will be referenced in our report.
Note
PRD supports adding one or more grouping criteria, but in our case...
